HomeFlySpeed SQL Querycomparing a field with average of all that column

comparing a field with average of all that column


Hi, I have a table like this

Name Weight
a 60
b 50
c 70

I need to list the person's name and weight who has more weight than the average weight of all persons. Is this possible in FlySpeed SQL Query? Thanks
ruleworld | email
March 9 2011, 10:56 PM
Yes, it is possible using SQL queries. Read more about this language here: http://www.google.com/search?q=sql+tutorial
Sergey Smagin | email
5 hours, 54 mins since original post
This topic is closed