Could anyone please tell me how to apply conditions on columns whihc are not a part of 'group by' clause?
For example, I wish to filter out those sections wherein the eldest member of a family is a male and has the value 'M' in its gender field....
select section_no,max(age) as 'Maximum Age' from table1 group by section_no
I now wish to apply (where gender='M')
How to do this??