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
- 51672 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
What is difference between stored procedure and trigger?
How can we optimize a sql query?
Who developed sql?
How do you rename a table in sql?
How do I order by ascending in sql?
How many types of literals are available in pl sql?
What is compound trigger?
How do I add a database to sql?
What is the difference between the implicit and explicit cursors?
What is cursor and why it is required?
What are inner and outer joins examples of both?
Do ddl statements need commit?
how many tables will create when we create table, what are they? : Sql dba
Can we use joins in subquery?
What is date functions?
