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
- 52633 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / a.balakrishna
select * from education where rowid in (select min(rowid)
from ex group by sno having count(*)>1);
100% it is true
Best of luck
9177509010
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
Is delete faster than truncate?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is a file delimiter?
explain commit and rollback in mysql : sql dba
What is sql query optimization?
Where is sql database stored?
Explain the the update statement in sql?
what are the 'mysql' command line arguments? : Sql dba
Explain locks? : Transact sql
what is rollback? : Sql dba
How do you know if a relationship is 2nf?
What is a database trigger?
How do I order by ascending in sql?
can sql servers linked to other servers like oracle? : Sql dba
