select count(empno)-count(distinct(empno)) from emp;

how do you count the duplicate records in a table

Question Posted / akki julak

Answer Posted / akki julak

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How does a trigger work?

1079

What is the sql query to display the current date?

1053

Can you select everything, but 1 or 2 fields, without writer's cramp?

988

What is break?

1203

How does pl sql work?

967

Difference between global and parameter variables?

1978

What is natural join in sql?

1002

what is the difference between a having clause and a where clause? : Sql dba

1097

What are the qualities of 2nf?

1046

How do I partition a table in sql?

1142

What has stored procedures in sql and how we can use it?

1088

How can we make an if statement within a select statement?

1021

What are tables in sql?

1073

How do I view output in sql developer?

1089

Why are sql stored procedures used?

1061