I have table-A(1,2,3,4,4,5,6,6,6,7).
how to get all duplicate values?what is sql query?
- 5 Answers
- 7465 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / sudipta santra
select * from A group by no having count(*)>1 ;
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Explain the use of full option in exp command.
How do we display rows from the table without duplicates?
How do I start tns listener?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Use of an integrity constraint is better to validate data. Explain
How to create a table index in oracle?
What are the execution control statements?
How to best split csv strings in oracle 9i?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to initialize variables with default values?
Explain the use of record length option in exp command.
How to work with data objects interactively?
Explain how you would restore a database using RMAN to Point in Time?
What is blob data type in oracle?
What is a cursor in oracle?
