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
- 50933 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / karthik
i think ths will work!
select * from table_name where rowid in (select max
(rowid) from table_name groupby duplicate_field_name);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Which is better stored procedure or query?
Differentiate between syntax and runtime errors.
What are sql ddl commands?
What is the difference between a database and a relational database?
How delete all records from table in sql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
what is denormalization. : Sql dba
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Is truncate ddl or dml?
What are the two types of cursors in pl sql?
What is data manipulation language?
What is sqlcontext?
What is left inner join in sql?
explain what is mysql? : Sql dba
What is the maximum size of sqlite database?
