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 is the current version of postgresql?

1005

In pl/sql, what is bulk binding, and when/how would it help performance?

937

Can we rollback after truncate?

980

What type of database is cloud sql?

1044

how to escape special characters in sql statements? : Sql dba

967

what are ddl statements in mysql? : Sql dba

1112

Why function is used in sql?

878

what is the stuff function and how does it differ from the replace function? : Sql dba

989

What are inner and outer joins examples of both?

879

what is the different between now() and current_date()? : Sql dba

934

Does group by remove duplicates?

979

What does stand for in sql?

916

What is a dynamic query?

971

What is memory optimized?

1009

How do you optimize a stored procedure in sql?

893