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 the use of function "module procedure" in pl/sql?

1198

Can we join two tables without common column?

1010

How do you remove duplicate records from a table?

942

Does mysql support pl sql?

1175

What is the advantage of nosql?

1061

What is mutating trigger?

1026

Why is nosql good?

1029

what is the difference between sql and t-sql? : Transact sql

1088

Does sql*plus also have a pl/sql engine?

1082

What is sql trigger example?

1067

How can a function retun more than one value in oracle with proper example?

1074

what is a unique key ? : Sql dba

1096

What is the sql case statement?

1011

What is normalization sql?

1063

How do I save the results of sql query in a file?

980