how do you count the duplicate records in a table
- 10 Answers
- 16194 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / suresh a
select sum(count(col1) -1) from emp
group by col1 having count(col1) > 1
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the different schemas objects that can be created using pl/sql?
How do I know if I have sql express or standard?
What are string functions in sql?
What does t sql mean?
What is integrity in sql?
Can we delete column in sql?
what are the different functions in sorting an array? : Sql dba
Are stored procedures faster than dynamic sql?
Can sql developer connect to db2?
What type of database is cloud sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Which one is better sql or oracle?
What is sorting in sql?
What is #table in sql?
How do temporal tables work?
