sqlÓï¾äÔõôд

±ít
ÓÐ×ֶΣºname,value×Ö¶Î
name----value
a-------1
a-------2
a-------3
a-------4
b-------3
b-------5
c-------2
c-------4
c-------6
²é³öÿ¸önameµÄvalue×î´óµÄÇ°3Ìõ¼Ç¼£¬¸Ãname¼Ç¼²»×ã3ÌõµÄ£¬²é³öÈ«²¿¡£
±ÈÈçbÖ»ÓÐÁ½Ìõ¼Ç¼£¬ÄǾÍÈ«²é³öÀ´ËãÁË
a¾Í²é³ö4£¬3£¬2
sqlserver µÄsqlÓï¾äÔõôд£¬Ð»Ð»¡£

---

·Ö×éÈ¡Ç°¼¸Ìõ£¬¸øÄãÕÒ¸öÀý×Ó¿´°É£¬ÎÒ˯ÁË

---

SQL code:
select *
from tb t
where
value in(select top value from tb where name=t.name order by value desc)

---

ÒýÓÃ

SQL codeselect*from tb twhere
  valuein(selecttop valuefrom tbwhere name=t.nameorderby valuedesc)

SQL code:
select *
from tb t
where
value in(select top 3 value from tb where name=t.name order by value desc)

---

SQL code:
---------------------------------
-- Author: liangCK СÁº
-- Title : ²éÿ¸ö·Ö×éÇ°NÌõ¼Ç¼
-- Date : 2008-11-13 17:19:23
---------------------------------

--> Éú³É²âÊÔÊý¾Ý: #T
IF OBJECT_ID('tempdb.dbo.#T') IS NOT NULL DROP TABLE #T
CREATE TABLE #T