sql语句写法

Question

select distinct top 2 fieldname,count(fieldname) As cc from tablename
 group by fieldname
 order by count(fieldname) desc

Answer 1

select top 2 fieldname,count(fieldname) As cc from tablename
 group by fieldname
 order by cc desc

Answer 2

select top 2 fieldname
from (
select fieldname,count(*) as cn from tablename
group by fieldname
) as x
order by cn desc

Answer 3

or:select top 2 fieldname
from tablename
group by fieldname
order by count(*) desc