Select* from emp where rowid not in(select max(rowid) from emp group by emp

how to retrieve only duplicate values in a table

Question Posted / siva

Answer Posted / siva

Select* from emp where rowid not in(select max(rowid) from emp group by empno);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I remove sql developer from windows 10?

696

Can a commit statement be executed as part of a trigger?

803

Which language is used in sql?

732

What are the different types of joins in sql?

1154

Can we create clustered index without primary key?

713

what is bdb (berkeleydb)? : Sql dba

755

what is oltp (online transaction processing)? : Sql dba

731

Define join and name different types of joins?

717

Is json a nosql?

723

Why are cursors used?

792

What is foreign key and example?

708

What is error ora-12154: tns:could not resolve the connect identifier specified?

827

What is example of database?

701

Can I learn sql in a week?

758

What is the execution plan in sql?

760