how do you count the duplicate records in a table
- 10 Answers
- 17338 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / purushotham
select column,count(1) from a
group by column
having count(1)>1;
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is package in pl sql with an examples?
Does truncate release storage space?
What is a pragma statement?
what is text? : Sql dba
Is a view faster than a stored procedure?
What are primary key and foreign key and how they work?
What are the types of optimization?
How is use pl and sql?
What is the mutating table and constraining table?
What does data normalization mean?
what are the advantages and disadvantages of views in a database? : Sql dba
Why is pl sql needed?
What is rownum?
Can we create clustered index without primary key?
What is varchar data type in sql?
