oracle 如何让重复的数据不显示 在 user 表中, 有email 这个字段,我现在想查询所有email 不含重复的数据 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select distinct email from user ? select email ,count(1) from user group by email having count(1)=1 楼上的大哥厉害,有个小问题哦, 如果我要是想在select 后查询出 所有的数据 该怎么写谢谢了 select * from user where email in (select email from user group by email having count(*)=1) select email ,count(1) from user group by email having count(1)=1 select * from user where id in (select id from (select max(id), email ,count(1) from user group by email having count(1)=1 )) select email from users where email in (select email from users having count(*)<2 group by email) 通过rowid来精确和高效处理重复数据问题吧SELECT *FROM USERSWHERE ROWID IN (SELECT MAX(ROWID) FROM USERS t GROUP BY t.email)ORDER BY 1 请问前辈,oracle的布局怎么固定,就是每次进来都是浮动窗口 修改列属性,菜鸟求救 oracle中表数据过多是否影响表间连接 哪位大侠能帮我写出具怎么做吗?把HR表空间里的所有表全部导入到其它表空间(CHENXP)..谢了 oracle安全的问题? 请教一个锁定数据库记录的问题 求一个查询语句,关于生日提醒。 大家都有什么工具来管理数据库字典和脚本? 请问oracle中date类型应该如何插入数据? 如何实现两个数据库之间的互访? ORA-01031: insufficient privileges Oracle10g如何创建数据库和实例
谢谢了
(select email from user group by email having count(*)=1)
select * from user where id in (
select id from (
select max(id), email ,count(1) from user group by email having count(1)=1
)
)
(select email from users having count(*)<2 group by email)
FROM USERS
WHERE ROWID IN (SELECT MAX(ROWID) FROM USERS t GROUP BY t.email)
ORDER BY 1