What is the Query to print out the individual total number of
duplicate row in sql.
- 5 Answers
- 10833 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
How do you sort in sql?
What is data definition language?
explain mysql aggregate functions. : Sql dba
What are the different schemas objects that can be created using pl/sql?
How to display Row Number with Records in Oracle SQL Plus?
what are the differences among rownum, rank and dense_rank? : Sql dba
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
Why do we need sharding?
What is the process of debugging?
What is sql select statement?
What is lexical units in pl sql?
What is 19 null in sql?
Explian rowid, rownum? What are the psoducolumns we have?
How do I add a primary key to a table?
What does pragma mean?
