SQL²éѯÓï¾ä¡£

±ÈÈçÒ»¸ö°à¼¶Ã¿¸öͬѧµÄ¿¼ÊÔ·ÖÊý£»
1.ÌáÈ¡¿¼ÊÔ·ÖÊýÇ°20ÃûµÄͬѧ£»
2.ÊäÈëÒ»¸öͬѧµÄÃû³Æ£¬¾ÍÄÜÖªµÀËûµÄÅÅÃû¡£
Çëд³öÓï¾ä»ò´æ´¢¹ý³Ì£¬Ð»Ð»

---

SQL code:
--1
SELECT TOP 20 * from TB ORDER BY ¿¼ÊÔ·ÖÊý DESC
--2
SELECT ÅÅÃû from (
SELECT
ÅÅÃû=(SELECT COUNT(*)from TB WHERE ¿¼ÊÔ·ÖÊý>=T.¿¼ÊÔ·ÖÊý)£¬
ÐÕÃû£¬
from TB T)A
WHERE ÐÕÃû='ÕÅÈý'

---

SQL code:
--ÔÚÍø°É£¬Ã»»·¾³²âÊÔ
--1
SELECT TOP 20 * from TB ORDER BY ¿¼ÊÔ·ÖÊý DESC
--2
SELECT ÅÅÃû from (
SELECT
ÅÅÃû=(SELECT COUNT(DISTINCT ѧºÅ)from TB WHERE ¿¼ÊÔ·ÖÊý>=T.¿¼ÊÔ·ÖÊý)£¬
ÐÕÃû£¬
from TB T)A
WHERE ÐÕÃû='ÕÅÈý'

---

SQL code:
SELECT ÐÕÃû,ÅÅÃû=(SELECT COUNT(*)from TB WHERE ¿¼ÊÔ·ÖÊý>=T.¿¼ÊÔ·ÖÊý)
from TB T
WHERE ÐÕÃû='ÕÅÈý'

---

SQL code:
--1.
select top 20 * from tb order by ¿¼ÊÔ·ÖÊý desc
--2
select
px
from
(select px=row_number()over(order by ¿¼ÊÔ·ÖÊý),ÐÕÃû from tb)t
where
ÐÕÃû='XX'

---

ÒýÓÃ

SQL codeSELECT ÐÕÃû,ÅÅÃû=(SELECTCOUNT(*)from TBWHERE ¿¼ÊÔ·ÖÊý>=T.