userid | flag |
---|---|
aa | 80 |
aa | 60 |
aa | 20 |
bb | 100 |
bb | 70 |
select b.* from
(select userid,max(flag) m from dbo.ksh_wyksny GROUP BY userid) t,dbo.ksh_wyksny b
where t.userid=b.userid and t.m=b.flag
userid | flag |
---|---|
aa | 80 |
aa | 60 |
aa | 20 |
bb | 100 |
bb | 70 |
select b.* from
(select userid,max(flag) m from dbo.ksh_wyksny GROUP BY userid) t,dbo.ksh_wyksny b
where t.userid=b.userid and t.m=b.flag