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 error ora-12154: tns:could not resolve the connect identifier specified?

1117

Why we use join in sql?

1022

Can I call a procedure inside a function?

1074

What is coalesce sql?

1050

Is sql a backend?

1070

What is data modelling in sql?

1071

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1120

How many types of sql are there?

1042

What are the different dml commands in sql?

1246

What is delimiter sql?

1058

What are the advantages of pl sql?

1160

Is sql similar to python?

1033

Who developed sql?

1091

Why do we use joins in sql?

1004

What is query optimization in sql?

1040