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
- 51089 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 are the three forms of normalization?
How do I run a sql query in pgadmin 4?
What is the best sql course?
Why is partition used in sql?
how to shut down the server with 'mysqladmin'? : Sql dba
Can I join the same table twice?
How to create your own reports in sql developer?
What are sql data types?
What are local and global variables and their differences?
What is the primary key?
What is full form of rtm?
what are date and time functions in mysql? : Sql dba
What are the operators in sql?
What is a primary key called that is made up of more than one field?
Why do we use function in pl sql?
