Count The Number Of Records Returned From A SELECT Query

[szlamany]

Select 1,Gender, Count(*) From Student_T Group by Gender

Union All

Select 2, 'Total', Count(*) From Student_T

Order by 1,2

[edit] hey - I passed 7000 posts!