select count(deptno), deptno from emp where rowid not in (select min(rowi

What is the Query to print out the individual total number of
duplicate row in sql.

Question Posted / ashish bakal

Answer Posted / ashish bakal

select count(deptno), deptno from emp where rowid not in
(select min(rowid) from emp group by deptno) group by
deptno;

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what are myisam tables? : Sql dba

1027

What is Difference Between Unique and Primary Key Constraints?

1101

Difference between table function and pipelined function?

1011

When is the explicit cursor used ?

1024

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1140

What is a boolean in sql?

972

What is sql procedures and functions?

999

Can we use threading in pl/sql?

1030

what is bcp? When is it used?

1101

What is the life of an sql statement?

1013

What is an ndf file?

985

What are the various levels of constraints?

1120

What is the use of pl/sql table?

1058

How to check if a column is nullable before setting to nullable?

1114

how many groups of data types? : Sql dba

1015