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
- 52618 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
Explain the select statement in sql?
what is cursor. write example of it. What are the attributes of cursor.
What is sql mysql pl sql oracle?
What is a sql trace file?
what are the security recommendations while using mysql? : Sql dba
What is primary key and foreign key?
How do I clear the screen in sql plus?
How do I write a sql query in pgadmin 4?
how to decrement dates by 1 in mysql? : Sql dba
What is the difference between sum and count in sql?
What is auto increment in sql?
What is trigger and types?
What is equi join in sql?
how can we optimize or increase the speed of a mysql select query? : Sql dba
what are the join types in tsql? : Transact sql
