Question

oracle 查询字段值重复sql语句

表 A 字段 b 想查询 b 字段有重复的数据。

Answer 1

你不知道你问的是不是这个意思
select b,count(1)
from A
group by b
having count(1)>1
order by b
;

Answer 2

select b,count(b) from A group by b

Answer 3

select b from a group by b having count(*)>1;

Answer 4

select * from A group by having count(*)>1;

Answer 5

dfgdgdsfsd