I have table-A(1,2,3,4,4,5,6,6,6,7).
how to get all duplicate values?what is sql query?
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
What are the various oracle database objects?
Is oracle an open source?
What happens if the update subquery returns multiple rows?
What is a tns file?
Explain about functional dependency and its relation with table design?
How to set up autotrace for a user account?
Differentiate between translate and replace?
Explain the use of log option in exp command.
What is the best way to do multi-row insert in oracle?
How to use fetch statement in a loop?
How to assign a tablespace to a users in oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How to drop an existing table in oracle?
How to end the current transaction in oracle?
What is a database schema in oracle?