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?
- 28 Answers
- 47455 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / "d"
select count(*),ss from dd group by
ss having count(*)>1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is Difference Between Unique and Primary Key Constraints?
What is the difference between left outer join and left join?
What are sql*plus environment variables?
In what condition is it good to disable a trigger?
Can we use join in subquery?
What is an exception in pl/sql?
What is a string data type in sql?
what are the differences between char and varchar? : Sql dba
Can we use pl sql in mysql?
What is bind variable in pl sql?
what are the join types in tsql? : Transact sql
Can a view be mutating? If yes, then how?
What is online transaction processing (oltp)?
What are synonyms in sql?
Which sorts rows in sql?
