select * from tmp_yx_user_0401_qy_ok where login_name
in (select login_name from tmp_yx_user_0401_qy_ok
group by login_name having count(login_name) > 1)
and rowid not in (select min(rowid) from tmp_yx_user_0401_qy_ok
group by login_name having count(login_name )>1)
亲,沙发正空着,还不快来抢?
我要评论 / 展开表单