這個sql語句應該怎樣寫？

[freekite]

table: Tscore
1.math 86
2.math 90
3.chinese 75
4.english 80
5.english 88
6.english 91
要得到 記錄最多的(english)和它的記錄數:
english 3

[CrazyFor]

select top 1 English字段名，count(*) as 数量 from 表 group by English字段名 order by 数量 desc

[ny64]

select top 1 科目 ,count(*)as row from Tscore group by 科目 order by row desc

[wuqiuzhi]

我觉得这样是不是更好写：

select sub,max(Score),count(*) from table where sub='english' group by sub

[Lastdrop]

用 ny64(海岛) 的SQL！

其他各位，注意english是查询出来的，不是事先指定或者知道的!

[SophiaWang]

select top 1 subject,count(subject) countsub
from Tscore
group by subject
order by countsub desc

[pengdali]

create table #Tscore(a int,b varchar(100),c int)
insert #Tscore values(1,'math', 86)
insert #Tscore values(2,'math', 90)
insert #Tscore values(3,'chinese', 75)
insert #Tscore values(4,'english', 80)
insert #Tscore values(5,'english', 88)
insert #Tscore values(6,'english', 91)

select top 1 b,count(*) 数量 from #tscore group by b order by count(*) desc

go
drop table #tscore

[happydreamer]

select top 1 字段1,count(*) from table group by 字段1
order by count(*) desc

[SophiaWang]

select top 1 subject,count(subject) countsub
from Tscore
group by subject
order by countsub desc

[freekite]

用order by count(*) 就可以
　order by [ ] 就不行
姜還是老的辣!!!

[HawaiiLeo]

呵呵，笨的方法
create table #Tscore(a int,b varchar(100),c int)
insert #Tscore values(1,'math', 86)
insert #Tscore values(2,'math', 90)
insert #Tscore values(3,'chinese', 75)
insert #Tscore values(4,'english', 80)
insert #Tscore values(5,'english', 88)
insert #Tscore values(6,'english', 91)

SELECT MAX(A.num) AS num FROM (SELECT COUNT(*) AS num FROM #Tscore GROUP BY b) A