Knight of the round table

wansong

SQL重复记录查询

select * from rbacUser
where name in (select name  from RbacUser  group  by name  having  count(name) > 1)


select * from rbacUser
where (name,groupId) in (select name,groupId  from RbacUser  group  by name,groupId  having  count(*) > 1)

posted on 2010-05-22 21:44 w@ns0ng 阅读(136) 评论(0)  编辑  收藏 所属分类: Database


只有注册用户登录后才能发表评论。
网站导航: