sqlserverÊý¾Ý¼Ó×ÜÅÅÐòµÄÓï¾äÔõôд£¿

sqlserverÊý¾Ý¼Ó×ÜÅÅÐòµÄÓï¾äÔõôд£¿
ÈçÏÂÊý¾Ý±ítable
id
a
a
a
b
b
c

ÎÒÒªµÃµ½µÄΪ£º
a 3
b 2
c 1

ÕâÑù¼Ó×ÜidÃû³ÆÒ»ÑùµÄ²¢½øÐÐÅÅÐòÓ¦¸ÃÔõôд£¿

---

SQL code:
select id,count(1) from tb group by id

---

SQL code:
SELECT *,(SELECT COUNT(1) from TB WHERE ID=T.ID)AS NUM
from TB T ORDER BY
(SELECT COUNT(1) from TB WHERE ID=T.ID) DESC

---

SQL code:
select id,count(1) as px from tb order by px desc

ÕâÑù£¿»¹ÊÇÇɺϣ¿

---

SQL code:
select id,count(1) from tb group by id ORDER BY 2 DESC

---

SQL code:
select id,count(1) as px from tb order by count(1) desc

---

SQL code:
---²âÊÔÊý¾Ý---
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([id] varchar(1))
insert [t