Çósql Óï¾ä - .NET¼¼Êõ / ASP.NET

id bh value time
K0011 01 25 2010-05-10 05:08:10
K0012 01 35 2010-05-10 05:10:10
K0013 01 35 2010-05-10 05:11:10
K0014 02 20 2010-05-10 05:08:11
K0015 02 50 2010-05-10 05:09:12
K0016 03 30 2010-05-10 05:08:10
K0017 03 25 2010-05-10 05:10:10
K0018 03 35 2010-05-10 05:10:10
K0019 01 35 2010-05-10 06:11:10
K0020 02 20 2010-05-10 06:12:10
K0021 02 40 2010-05-10 06:13:10
K0022 03 30 2010-05-10 06:14:10

ËùÓеÄ
id bh value time
K0019 01 35 2010-05-10 06:11:10
K0015 02 50 2010-05-10 05:09:12
K0018 03 35 2010-05-10 05:10:10

Éú³ÉËùÓбàºÅ×î´óÖµ£¬Èç¹ûÅöµ½×î´óÖµÓÐÏàͬµÄÔòȡʱ¼ä×î´óµÄÄǸö¡£

---

;wit tb as
(
  select xuhao = row_number() over (partition by bh order by value desc,time desc),
  id,bh,value,time
  from table
)

select id,bh,value,time
from tb
where xuhao=1

---

ÒýÓÃ

;wit tb as
(
select xuhao = row_number() over (partition by bh order by value desc,time desc),
id,bh,value,time
from table
)

select id,bh,value,time
from tb
where xuhao=1

Õý½â£¬Õë¶Ôsql2005ÒÔÉÏ°æ±¾

---

C# code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHig