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

How can one get sql*loader to commit only at the end of the load file? : aql loader

748

What are the different parts of a package?

812

What is a loop in sql?

744

What does varchar include?

683

What is substitution variable in pl sql?

693

explain what is mysql? : Sql dba

787

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

842

What is sql deadlock?

741

Whis is not false in primary key?

1169

What is sql not null constraint?

777

what is a join? : Sql dba

769

Why plvtab is considered as the easiest way to access the pl/sql table?

835

What is the maximum database size for sql express?

722

How does a trigger work?

718

How can we solve sql error: ora-00904: invalid identifier?

885