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

State some properties of relational databases?

1001

What are the uses of sysdate and user keywords?

1048

What are the string functions in sql?

922

When do we use triggers?

1025

how do you control the max size of a heap table? : Sql dba

919

How do you explain an index number?

1021

Mention what are the benefits of pl/sql packages?

999

What are two statement types in sql?

1029

how do you know if your mysql server is alive? : Sql dba

1024

Explain spool.

1104

What is partition by in sql?

1000

What is the difference between local variables and global variables?

1067

What is sql entity?

1028

how do you login to mysql using unix shell? : Sql dba

1015

What is difference between procedure and trigger?

914