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
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is prepared statement in sql?
Which normal form is best?
Who is the owner of mysql database?
what are date and time intervals? : Sql dba
Is it possible to update views?
Is sql microsoft?
What is autocommit sql?
Why is a trigger used?
What are stored procedures in mysql?
Which type of cursor is used to execute the dml statement?
What is the difference between stored procedure and view?
Is sqlite good enough for production?
How many columns should be in an index?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba