query to display name and average salary who are having age>50

[doll]

hi all
i have a table called persons and the feilds are name,id,salary, age..i need to display the name and average salary of the people whos age is more than 50..what is the query for this..someone please tell me the query for this..

thanking you

[azimmer]

hi all
i have a table called persons and the feilds are name,id,salary, age..i need to display the name and average salary of the people whos age is more than 50..what is the query for this..someone please tell me the query for this..

thanking you

Name and average salary don't go together -- what would that mean? Do you need name and salary of people over 50; or do you need the average salary of (all) people over 50?

[doll]

Name and average salary don't go together -- what would that mean? Do you need name and salary of people over 50; or do you need the average salary of (all) people over 50?

hi
thanks for the reply..but i myself dont know what does the question mean..this was asked to me in a test and i dint know the query..name and avg salary wont go together is it..or you mean to say aggregate function does not go with name..i dint get you

thank you

[azimmer]

hi
thanks for the reply..but i myself dont know what does the question mean..this was asked to me in a test and i dint know the query..name and avg salary wont go together is it..or you mean to say aggregate function does not go with name..i dint get you

thank you

1. Please do not use this forum to solve your (or someone else's) coursework. It goes against the forum rules. Read and obey this please: http://www.thescripts. com/forum/faq.php?faq=pos ting_guidelines #faq_homework_o r_coursework
2. Please understand at least what you want before asking questions.
3. It helps a lot to make an effort yourself...

[doll]

1. Please do not use this forum to solve your (or someone else's) coursework. It goes against the forum rules. Read and obey this please: http://www.thescripts. com/forum/faq.php?faq=pos ting_guidelines #faq_homework_o r_coursework
2. Please understand at least what you want before asking questions.
3. It helps a lot to make an effort yourself...

hi
ok thanks a lot...sorry