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?
- 28 Answers
- 43972 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / seshu
SELECT RNO,NAME,COUNT(*) REP_COL FROM Education GROUP BY
RNO,NAME having Count(*)>1;
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Does a primary key have to be a number?
Is left join inner or outer by default?
Can we call a function containing dml statements in a select query?
what are ddl statements in mysql? : Sql dba
Is sql sequential or random?
What is scalar function in sql?
What is cross join example?
Is sql a scripting language?
Is pl sql and postgresql same?
Why do we use subquery?
how to calculate the difference between two dates? : Sql dba
Why do we need cursor in pl sql?
What is crud stand for?
What do you mean by query optimization?
What are reports usually used for?
