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
- 52638 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
What is a constraint?
How many types of triggers exist in pl/sql?
How do I truncate a sql log file?
What are sql objects?
How to process query result in pl/sql?
What is nvarchar max in sql?
What is restrict in sql?
How many commands are there in sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What are the syntax and use of the coalesce function?
What does cursor do in sql?
How to call a javascript function from pl sql?
What is the difference between alter trigger and drop trigger statements?
What does inner join mean?
is it possible to pass an object or table to a procedure as an argument?
