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

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 / sam

Answer Posted / sam

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

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is varray?

1031

What is the order of defining local variables and sub procedures/functions?

1003

What is a private synonym?

1525

How to set a transaction to be read only in oracle?

1030

What is an anonymous block?

1154

Does facebook use oracle?

976

What is java oracle used for?

963

What is an oracle transaction?

1049

What is system global area (sga) in oracle?

925

What is the usage of save points in oracle database?

904

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2205

what is the difference between data migration and production migration.

2272

Explain alias?

1077

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2994

How to get execution statistics reports on query statements?

1004