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

what is primary key? : Sql dba

1009

What is the purpose of using pl/sql?

1125

Is sql better than excel?

1118

What's the difference between a primary key and a clustered index?

976

What are inner outer left and right joins in sql?

997

Why do we use partitions in sql?

1032

how to use myisamchk to check or repair myisam tables? : Sql dba

957

Are subqueries better than joins?

957

Explain the working of foreign key?

1047

Are dml statements autocommit?

1028

What are string functions in sql?

1219

What is primary key sql?

1015

Determine if oracle date is on a weekend?

1026

What is the trigger in sql?

929

What is foreign key and example?

917