About Query--Example: Query the most male class

The writing in Oracle database:

1. Using subqueries

Select Max (A.mailcount) from (select count (b.id) mailcount,basic_organ_id from T_card_basic b 
where b.basic_sex = ' Male ' 
GROUP by b.basic_organ_id) A;

2. Using Oracle's featured RowNum

Select basic_organ_id, A, rownum from (select Basic_organ_id,count (*) as a from
t_card_basic 
where basic_sex = ' Male '
GROUP BY basic_organ_id ORDER by 
a desc
where rownum = 1

The writing in the SQL Server database:

Select top 1 classid,count (*) as a from
Student 
where sex = 1 
GROUP by ClassID ORDER by  
a desc