sql - ORDER BY and GROUP BY doesn't work for me -

sql - ORDER BY and GROUP BY doesn't work for me -

i've table called "emps" contain 5 cols (id, name, gender, birthdate, profession) , need

select * emps order id grouping gender, birthdate

but doesn't work!!

any help..

thanks

since gender , birthdate grouping items,so must select items.

select gender ,birthdate emps grouping gender,birthdate,id order id

sql vb.net order group