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

11. Display the client number and name and the client number and name of the person who referred that client.

2321

Can you assign multiple query result rows to a variable?

966

How to view existing locks on the database?

1031

Can we protect our pl/sql source code?

1029

What is snapshot is too old? Give and example for better understand.

1591

What is the fastest query method to fetch data from the table?

1343

How to assign values to variables?

1078

what are the advantages of running a database in archive log mode?

2186

Can we use bind variables in oracle stored procedure?

934

master table and child table performances and comparisons in Oracle ?

2118

What is a tns file?

977

What happens if you use a wrong connect identifier?

1037

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1327

What is Undo Management Advisor in Oracle?

1080

How will you identify oracle database software release?

988