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

How to connect to a remote server?

1192

Explain the use of Merge statement in oracle 11g

1077

What is a sub query and what are the different types of subqueries?

1174

How to create a table index in oracle?

1186

What are the predefined tablespaces in a database?

1145

Can we use bind variables in oracle stored procedure?

987

How do I uninstall oracle 11g?

1178

What is the minimum client footprint required to connect c# to an oracle database?

1162

Explain the difference between replace() and translate() functions in oracle?

1086

How to create an oracle database manually?

1132

What is the difference between I and G in Oracle?

1152

How to define a variable to match a table column data type?

1039

Which are the five query types available in oracle?

1001

How to retrieve data from an explicit cursor?

1109

What is private procedure oracle?

1050