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 restart sql?

928

What is a database trigger?

1034

Is left join same as inner join?

1048

how can we know the number of days between two given dates using mysql? : Sql dba

1010

Why is theta join required?

1100

How to connect a sql*plus session to an oracle server?

1091

what are the advantages of mysql in comparison to oracle? : Sql dba

952

what is 'mysqladmin' in mysql? : Sql dba

987

What is a sql*loader control file?

1189

What is the current version of sql?

994

How do sql databases work?

965

What is procedure and function?

944

What is the purpose of a secondary key?

918

What is foreign key sql?

954

What is identity column in sql server?

1006