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
- 52593 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sirisha
select id,count(id) from Education group by id having count(id)>1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between delete and truncate statement in sql?
What are the two types of exceptions in pl/sql?
What is the difference among union, minus and intersect?
Is sql a backend language?
What is an inner join sql?
How to combine two stored procedures in sql?
Can we join 3 tables in sql?
What is the command used to fetch first 5 characters of the string?
how to rename an existing table in mysql? : Sql dba
What is a sql*loader control file?
Is primary key clustered or nonclustered?
Can one improve the performance of sql*loader? : aql loader
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What is difference between inner join and self join?
Which are the different types of indexes in sql?
