SELECT * FROM emp WHERE ROWID NOT IN(SELECT MIN(ROWID)FROM emp GROUP BY e

What is the Query to print out the individual total number of
duplicate row in sql.

Question Posted / vivek ghorad

Answer Posted / vivek ghorad

SELECT * FROM emp WHERE ROWID NOT IN(SELECT MIN(ROWID)FROM
emp GROUP BY empno,fname,dept);

Is This Answer Correct ?

3 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Why truncate is faster than delete?

1062

Why is pl sql used?

948

How do I copy a table in sql?

940

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

920

Why do we use procedures in sql?

1032

What are pl/sql cursor exceptions?

1040

Why select is used in sql?

978

What are local and global variables and their differences?

1055

how can we destroy the cookie? : Sql dba

966

what does the t-sql command ident_current does? : Transact sql

938

What are the types of functions in sql?

972

What normalization means?

915

What is the difference between instead of trigger and after trigger?

958

How do I clear the screen in sql plus?

990

what are myisam tables? : Sql dba

967