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
- 43991 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
How many joins can you have in sql?
How do I remove duplicates in two columns?
What problem one might face while writing log information to a data-base table in pl/sql?
What are the different types of tables in sql?
Can I join the same table twice?
what are all types of user defined functions? : Sql dba
How is data stored on a disk?
How do you add a column to a table?
What does joining a thread mean?
Does a join table need a primary key?
Why self join is used in sql?
how to use 'mysql' to run sql statements? : Sql dba
How delete all data from all tables in sql?
Why use subqueries instead of joins?
How do I sort a table in sql?
