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
- 51167 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / harish
select * from education where rownum < ( select max(rownum)
from education group by <column_name> )
| Is This Answer Correct ? | 15 Yes | 24 No |
Post New Answer View All Answers
Which data dictionary views have the information on the triggers that are available in the database?
Where can I learn sql for free?
Is join an inner join?
How is pl sql different from sql?
What is the use of stored procedures?
What is cross join sql?
What is function and procedure?
What is the usage of distinct keyword?
What are the disadvantages of not performing database normalization?
how to install mysql? : Sql dba
Describe types of sql statements?
Name three sql operations that perform a sort.
What is the difference between the conventional and direct path loader? : aql loader
Difference between table function and pipelined function?
Does normalization improve performance?
