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

Is it possible to read/write files to-and-from PL/SQL?

1035

What are the advantages of indexing?

926

What is difference between hql and sql?

991

What is posting?

990

How to Declare Fixed Length String Value In PL SQL

1102

how to create a new table in mysql? : Sql dba

932

what are date and time data types in mysql? : Sql dba

917

What is data control language (dcl)?

1043

What is difference between table and view?

974

How many types of keys are there in sql?

986

explain the options of myisamchk to improve the performance of a table. : Sql dba

950

How do you explain an index number?

1022

Is sql free?

886

Does a user_objects view have an entry for a trigger?

959

What are the popular database management systems in the it industry?

925