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 all the different types of indexes?

1195

what is msql? : Sql dba

1044

What is package in pl sql with an examples?

1083

Why do we use procedures in sql?

1138

What are the properties of a transaction?

1185

What are the different type of joins in sql?

997

how to rename an existing column in a table? : Sql dba

1076

what is schema? : Sql dba

1106

How much ram can sql express use?

1037

What is data profiling in sql?

1133

What does a pl/sql package consist of?

1014

What is the advantage of index in sql?

1014

Explain the insert into statements in sql?

1051

Explain what is an index?

1104

Is left join faster than inner join?

1168