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

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 / sudipta santra

Answer Posted / sudipta santra

Is This Answer Correct ?

7 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How do I know if oracle is installed on windows?

908

How oracle handles dead locks?

1052

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1120

What is difference between truncate and delete?

1017

What are the types of partitions in oracle?

1016

How would you go about verifying the network name that the local_listener is currently using?

2024

Where are the settings stored for each instance in oracle?

1092

What are the differences between char and varchar2 in oracle?

1140

Explain rename?

959

How to use subqueries with the in operator using oracle?

1069

How many data types are supported?

1065

Can you assign multiple query result rows to a variable?

964

What is the difference between alert log file and tarce file ?

2148

What privilege is needed for a user to create views in oracle?

1022

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2087