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 execute immediate?

1084

Show how functions and procedures are called in a pl/sql block.

1127

how to install mysql? : Sql dba

1109

how to use regular expression in pattern match conditions? : Sql dba

1031

what are the advantages and disadvantages of views in a database? : Sql dba

1043

What is indexing oracle sql?

1105

What is sql and also describe types of sql statements?

1066

How much does sql cost?

1000

What is the current version of sql?

1023

What are the types of sql commands?

1103

What does the sign mean in sql?

989

What is %s in sql?

1015

What is sql and its types?

1187

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1068

How to assign sql query results to pl sql variables?

1078