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 the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2173

Is it possible to insert comments into sql statements return in the data model editor ?

2635

How to delete an existing row from a table in oracle?

1128

Give the different types of rollback segments.

1076

Â How to use an oracle sequence generator in a mapping?

1129

Why do you use stored procedures and state some of its disadvantages?

1071

please explain.. DB architecture ...

2080

How to insert a new row into a table in oracle?

1214

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2040

How do I learn what codesets are available in oracle?

1076

How to drop a tablespace?

1084

What is the difference between substr & instr functions?

1292

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1093

Explain the use of record option in exp command.

1065

Can you have more than one content canvas view attached with a window ?

2369