Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve Duplicate Rows only in a Table?
Suppose if a Table Name is "Education". It consists of
multiple columns. Then if we insert rows into this table
with duplicate records then how can we retrieve only
duplicate records from that table?
- 29 Answers
- 50643 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / naresh
select * from emp where sal in(select sal from emp group by
sal having count(sal)>1);
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How many sql statements are used? Define them.
How many commands are there in sql?
What is the maximum number of triggers, you can apply on a single table?
Why is partition used in sql?
What does where 1 1 mean in sql?
How do I remove all records from a table?
How to select 10 records from a table?
Which data dictionary views have the information on the triggers that are available in the database?
How many scalar data types are supported in pl/sql?
What are different categories of sql commands?
Is it possible to sort a column using a column alias?
What is cursor explain with example?
Explain the select statement in sql?
What are tables in sql?
How do you delete a table?
