Interested to Buy Any Domain ? << Click Here >> for more details...
how do you count the duplicate records in a table
- 10 Answers
- 18526 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
How is data stored in sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is the sql case statement?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
Explain what is a column in a table?
What does cursor do in sql?
What is server name sql?
When is the explicit cursor used ?
What if we write return in procedure?
Is it possible to link two groups inside a cross products after the cross products group has been created?
what's the difference between a primary key and a unique key? : Sql dba
Explain two easy sql optimizations.
What are the types of variable use in pl sql?
What do you think about pl/sql?
How to change the order of columns in Oracle SQL Plus ?
