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

What is index example?

992

What is the reports view in oracle sql developer?

958

What are aggregate functions in sql?

1140

How can you tell the difference between an index and a view?

917

what is subquery? : Sql dba

1111

Why query optimization is needed?

908

Explain sql data types?

1077

Why we use pl sql?

943

what happens if null values are involved in expressions? : Sql dba

1029

What is the use of nvl function?

1175

what is offset-fetch filter in tsql? : Transact sql

932

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

994

What is acid property in a database?

1017

Explain the steps needed to create the scheduled job?

1023

How do I access sql anywhere database?

953