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
- 51837 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rajesh kumar patnaik
SELECT ProductName
FROM Products
WHERE (ProductName IN
(SELECT ProductName
FROM Products
GROUP BY ProductName
HAVING COUNT(*) > 1))
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
Is inner join same as self join?
Which are the different character-manipulation functions in sql?
What is function and procedure?
How do I send sql query results to excel?
How do you select unique values in sql?
What are its different types of dbms?
What is type and rowtype in pl sql?
Does group by remove duplicates?
What are system versioned tables?
Is join and inner join the same?
what is row? : Sql dba
Does sql require a server?
How can I speed up sql query?
Explain correlated query work?
How does sql store data?
