取最大值

[yz727272]

字段AA BB  cc



aa             bb           cc        
 
李小姐         苹果             55
李小姐         香蕉             120




求李小姐吃哪种水果最多。

[xuexiaodong2009]

[Quote=引用 3 楼 maco_wang 的回复:]

SQL code

select top 1 * from tb where aa='李小姐' order by cc desc
[/Quote]可以

[GoAwayZ]

select top 1 * from tb where aa='李小姐' order by cc desc

[AcHerat]

select *
from tb t
where not exists (select 1 from tb where aa = t.aa and cc > t.cc)

[叶子]

select top 1 * from tb where aa='李小姐' order by cc desc