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 can I see all tables in sql?

987

What is trigger with example?

1012

Can we create clustered index without primary key?

899

What is union, minus and interact commands?

1213

how to write date and time literals? : Sql dba

913

how can we repair a mysql table? : Sql dba

914

What does the base_object_type column shows in the user.triggers data dictionary view?

996

Does sqlite need a server?

994

What is foreign key and example?

886

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1019

What operators deal with null?

1029

What are different functions in sql?

897

Is left join inner or outer by default?

973

What is synonyms?

999

How do we use distinct statement? What is its use?

976