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
- 50678 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / keerthana
select Student_Name,Dgree from Education
group by (Student_Name,Dgree) having count(*) > 1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we use loop in sql?
What are some emotional triggers?
What trigger means?
How to use sql statements in pl/sql?
Why do we use procedures?
Does sql*plus have a pl/sql engine?
State some properties of relational databases?
What are the constraints available in sql?
What is the use of pl/sql table?
Can we join two tables without common column?
How do you explain an index?
Is trigger a stored procedure?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What is string data type in sql?
What does count (*) do in sql?
