how do you count the duplicate records in a table

Answer Posted / akki julak

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

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

644


What is prepared statement in sql?

545


Which normal form is best?

515


Who is the owner of mysql database?

553


what are date and time intervals? : Sql dba

566






Is it possible to update views?

540


Is sql microsoft?

546


What is autocommit sql?

538


Why is a trigger used?

525


What are stored procedures in mysql?

560


Which type of cursor is used to execute the dml statement?

530


What is the difference between stored procedure and view?

530


Is sqlite good enough for production?

531


How many columns should be in an index?

518


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

557