17,381
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
iagcel 2003-11-26
- 打赏
- 举报
怎么感觉你这个问题有点像华为的笔试题啊
rzxml 2003-11-26
- 打赏
- 举报
同意jiezhi()
tsj68 2003-11-26
- 打赏
- 举报
不同的行是不是所有字段中至少有一个字段不同吗?
如果是这样可以试试这个:
select col1,col2,...,coln,count(*) from tablename group by col1,col2,...,coln
如果是这样可以试试这个:
select col1,col2,...,coln,count(*) from tablename group by col1,col2,...,coln
beckhambobo 2003-11-26
- 打赏
- 举报
select * from
(select a.*,rank() over(partition by col_name order by rownum) rm from tabname a)
where rm>1
(select a.*,rank() over(partition by col_name order by rownum) rm from tabname a)
where rm>1
hdkkk 2003-11-26
- 打赏
- 举报
yes!
jiezhi 2003-11-26
- 打赏
- 举报
不相同的行
select distinct ... from ...
重复次数
select col1,count(*) from a group by col1 having count(1)>1
select distinct ... from ...
重复次数
select col1,count(*) from a group by col1 having count(1)>1
