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 are the types of trigger in oracle?

984

Explain an exception?

999

How to list all tables in your schema?

1053

Explain the use of grant option in imp command.

1030

Explain do view contain data?

1013

What is the Tune Query

2292

What do you mean by redo log file mirroring?

1032

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

What is the difference between substr & instr functions?

1228

How can we view last record added to a table?

1038

What is the difference between truncate & delete command?

1183

How to use select statement to count the number of rows in oracle?

1046

What are dml statements in oracle?

1095

How to view existing locks on the database?

1053

Is there a function to split a string in plsql?

1062