how to retrieve only duplicate values in a table

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where is all the data on the internet stored?

558


What is coalesce in sql?

566


What is sql in oracle?

626


What is plpgsql language?

534


Can a table have no primary key?

561






what is blob? : Sql dba

564


Differentiate between pl/sql and sql?

621


What is nvarchar max in sql?

584


What are the advantages of stored procedure?

544


What is bind reference and how can it be created?

582


list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

513


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1648


What is difference between group by and partition by?

502


explain the difference between delete , truncate and drop commands? : Sql dba

553


What is pls integer?

586