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
How to select some columns from a table in oracle?
How to connect ms access to oracle servers?
What do you mean by cdb and pdb in oracle 12c?
What is the difference between view and materialized view in Oracle?
Give the constructs of a package, function or a procedure.
Explain the use of grant option in imp command.
Explain the use of consistent option in exp command.
How to define a variable to match a table column data type?
Explain integrity constraint?
How to start a new transaction in oracle?
What is transport network substrate (tns) in oracle?
Explain alias?
What is system global area (sga) in oracle?
How do I uninstall oracle client from windows?
How to create a stored program unit?