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
- 50680 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / amit
select * from taruntest1 b where rowid not in (select min
(rowid) from taruntest1 a where a.a=b.a );
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What is sp_helptext?
Can we use ddl commands in pl sql?
What is recursive join in sql?
Is natural join same as inner join?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What are different types of statements supported by sql?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Which data type is a composite type?
what does it mean to have quoted_identifier on? : Sql dba
define sql update statement ? : Sql dba
How long does it take to learn pl sql?
What is sql and its types?
What are the different tcl commands in sql?
