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

definition of cluster and non-clustered index?

2479

Can the query output be sorted by multiple columns in oracle?

574

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1633

What is meant by joins? List out the types of joins.

526

What is the difference between translate and replace?

560

How to list all user accounts in oracle?

612

Explain how you would restore a database using RMAN to Point in Time?

1634

What is index-organized table in Oracle?

573

Explain user account with reference to oracle.

534

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1470

How to write numeric literals in oracle?

612

What is meant by raw datatype?

570

How to update values on multiple rows in oracle?

602

Explain overloading. Can functions be overloaded?

573

How to generate query output in html format?

566