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

What are different clauses used in sql?

1174

Explain what is sql?

1182

How do you create an update query?

1025

What is recursive stored procedure?

1141

Is a foreign key always unique?

984

How many sql statements are used? Define them.

1081

The select into statement is most often used to create backup copies of tables or for archiving records?

1120

Can we use loop in sql?

1011

What does count (*) mean?

986

What are stuff and replace function?

1143

What are the rules to be applied to nulls whilst doing comparisons?

1369

What is set serveroutput on in pl sql?

1361

Does sql require a server?

1055

How do you pronounce sql?

1061

How do you respond to dementia behavior?

1015