I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sq

I have table-A(1,2,3,4,4,5,6,6,6,7).
how to get all duplicate values?what is sql query?

Question Posted / venkat

Answers were Sorted based on User's Feedback

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?..

Answer / vikas

select *
from a
where rowid not in (select min(rowid) from a group by no)

no is column in table a;

Is This Answer Correct ?

10 Yes

2 No

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?..

Answer / sudipta santra

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

Is This Answer Correct ?

7 Yes

3 No

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?..

Answer / sam

SELECT num,
COUNT(num) AS NumOccurrences
FROM A
GROUP BY num
HAVING ( COUNT(num) > 1 )

Is This Answer Correct ?

3 Yes

0 No

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?..

Answer / nathan

SELECT sal,rn
FROM (SELECT ROW_NUMBER () OVER (PARTITION BY sal ORDER BY
empno DESC) rn,
sal
FROM emp)
WHERE rn > 1;

Is This Answer Correct ?

0 Yes

0 No

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?..

Answer / a.brahmam

delete from table name
where rowid not in(select max(rowid) from table name group by column name)

Is This Answer Correct ?

0 Yes

0 No