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

When is the update_statistics command used?

1089

Can we call stored procedure in function?

939

What are the features of pl sql?

1049

What is using in sql?

1062

What is vector point function?

1026

In what condition is it good to disable a trigger?

995

What are the different sql commands?

1052

What is before trigger?

988

What is difference between sql and excel?

1070

What is difference between procedure and trigger?

962

What if we write return in procedure?

1400

Which one is better sql or oracle?

950

What is out parameter used for eventhough return statement can also be used in pl/sql?

1058

How can you know that statistics should be updated?

1064

What are primary key and foreign key and how they work?

961