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

What is format trigger?

2077

What is a sub query? What are its various types?

1188

How to create id with auto_increment on oracle?

995

How many types of tables are there in oracle?

1064

How to loop through data rows in the implicit cursor?

1082

What is an oracle transaction?

1156

Why does for update in oracle 8 cause an ora-01002 error?

1011

What is an oracle user role?

992

Can objects of the same schema reside in different tablespace?

1069

How to empty your oracle recycle bin?

1029

Compare and contrast between sql and sql server and explain its various functions?

973

What is an Oracle Instance?

1132

How to check database size in Oracle?

1199

what is dynamic SGA and static SGA

4426

How remove data files before opening a database?

1080