seelct a.* from itest a,(
select top 1 iname,sum(ipay) from itest group by iname order by sum(ipay) desc
) as t
where a.iname=t.iname
select top 1 iname,sum(ipay) from itest group by iname order by sum(ipay) desc
) as t
where a.iname=t.iname
where iname =(
select top 1 iname from itest group by iname order by sum(ipay) desc)
-->
select
或者:select a.* from itest a
where not exists (
select iname,sum(ipay) from itest
where iname<>a.iname
group by iname
having sum(ipay)>(
select sum(ipay) from itest
where iname=a.iname
)
)
select * from itest
where iname in (
select top 1 iname from itest group by iname order by sum(ipay) desc)