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
- 51934 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
what is the difference between cluster and non cluster index? : Sql dba
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is clustered index in sql?
Why are indexes and views important to an organization?
Do ddl statements need commit?
What is bulk collect in pl sql?
How to convert comma separated string to array in pl/sql?
What is left join in postgresql?
What is the difference between distinct and unique in sql?
What is sql injection owasp?
What do you mean by dbms? What are its different types?
What is the cause of mutating table error and how can we solve it?
Can sql function call stored procedure?
What does count (*) do in sql?
Can we call a function containing dml statements in a select query?
