如果相同的UserID没有Flag相同的话 Select * from 表 A Where Exists(Select * from 表 Where UserID=A.UserID And Flag>A.Flag Having Count(*)<2 ) Order By UserID,Flag
关于 Lwg0901(伤心人) 的语句是有问题的 增加一个自增列id select * from t where id in (select max(id) from t group by userid union select min(id) from t group by userid)如果max(userid) 的记录同时有三条的话,那这三条都会被选出来
to ancyzhou() : id为自增列,除非你强行使id列有相同值,否则不会有“max(id)的记录同时有三条的话”谢谢
select * from t where id in (select max(id) from t group by userid union select min(id) from t group by userid)
如果相同的UserID没有Flag相同的话
Select * from 表 A
Where Exists(Select * from 表 Where UserID=A.UserID And Flag>A.Flag Having Count(*)<2 )
Order By UserID,Flag
增加一个自增列id
select * from t where id in (select max(id) from t group by userid union select min(id) from t group by userid)如果max(userid) 的记录同时有三条的话,那这三条都会被选出来
id为自增列,除非你强行使id列有相同值,否则不会有“max(id)的记录同时有三条的话”谢谢
select max(UserId) as UserId from tablename group by UserID
union all
select min(UserID) as UserId from tablename group by UserID