SQL查詢，按性別顯示學生信息，並分別匯總男生女生人數
如果性別在表Student中的列名稱為“sex”的話，那麽查詢語句分別是：
按性別顯示學生信息
Select * from Student order by sex
匯總學生人數
select sex,count(*) as cnt from student group by sex
按性別顯示學生信息
Select * from Student order by sex
匯總學生人數
select sex,count(*) as cnt from student group by sex