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 are schema-level triggers?

1102

how to create a table index in mysql? : Sql dba

1061

Is not null in sql?

994

Explain the methods used to protect source code of pl/sql.

1019

What are the different set operators available in sql?

1026

What is the starting oracle error number? What is meant by forward declaration in functions?

994

what are all types of user defined functions? : Sql dba

1042

What are the dml statements?

1143

What language is oracle sql developer?

1017

How delete all data from table in sql?

1016

what is a field in a database ? : Sql dba

1055

Are null values same as that of zero or a blank space?

1026

How can you create an empty table from an existing table?

1079

How subquery works in sql?

1067

What are sql built in functions?

936