I have some data inside a database and i would like to group them by Gender if possible.
For example there is around 300 entries mixture of women and men.
I would like to be able to Group them by the M and F and then sort them out accordingly into groups. where something 1 and something 2 are columns.
This data ideally should be exported to an excel file if possible. Many thanks for your time.
SOMETHING 1 SOMETHING 2
My question is can you use SQL server standard query of "group by" or is there something special you need to do?
Any examples would be fantastic or an explanation on how to do it.