declare @a table(id char(10), [user] char(10), vote int)
insert into @a select
'001', 'k', 7 union all
select '001', 'y', 8 union all
select '002', 'k', 9 union all
select '003', 'k', 10
select * from @awhere vote in(select max(vote) from @a
group by [user]) order by vote desc
result:
id user vote
---------- ---------- -----------
003k
10
001y
8
(所影响的行数为 2 行)
|