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 do you create a unique index?

565

What are triggers and its types?

549

what are the differences between char and nchar? : Sql dba

590

Is ms sql is free?

526

What is a temp table?

562

What is oracle and pl sql?

659

Can function return multiple values in sql?

521

Is left join same as join?

517

What is attribute indicator in pl sql?

519

What are the different set operators available in sql?

563

Does truncate table reset auto increment?

524

What are the two types of cursors in pl sql?

532

What is embedded sql what are its advantages?

502

Why is nosql good?

589

how to enter binary numbers in sql statements? : Sql dba

487