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 sqlite free?

949

What are pl/sql packages?

1085

what are the nonstandard string types? : Sql dba

1121

what is the difference between $message and $$message? : Sql dba

981

How to change sql*plus system settings?

1042

What does select top 1 do in sql?

1077

What is implicit cursor in pl sql?

1072

Why is partition used in sql?

1104

what is innodb? : Sql dba

1085

What version is sql?

1007

What is pl sql package?

1022

How is a process of pl/sql compiled?

1134

What's the procedure?

916

what is the difference between delete and truncate statement in sql? : Sql dba

1213

Can we rollback after truncate?

1012