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
- 47739 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 lookup table in sql?
Which table is left in left join?
What is sql injection vulnerability?
Which is better trigger or stored procedure?
What makes a good primary key?
what are tables and fields? : Sql dba
What does select * from mean in sql?
what is the use of double ampersand (&&) in sql queries?
How to convert comma separated string to array in pl/sql?
What is the purpose of using pl/sql?
What are sql queries used for?
What are secondary keys?
what is 'mysqlimport'? : Sql dba
What is the difference between joins?
what is dbms? : Sql dba
