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
- 50716 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / naresh
select * from emp where sal in(select sal from emp group by
sal having count(sal)>1);
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
how to select first 5 records from a table? : Sql dba
Why is a primary key important?
Is left join same as inner join?
What are the different ddl commands in sql?
How much does sql certification cost?
Which sql statement is used to delete data from a database?
What is dense_rank?
What is the difference between subquery and correlated query?
What are sql*plus environment variables?
How can you load microsoft excel data into oracle? : aql loader
Is sqlite thread safe?
Is merge a dml statement?
What is exit statement?
How can triggers be used for the table auditing?
What is the command used to fetch first 5 characters of the string?
