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
- 52612 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / cesar di sanctis
select * from <table_name>
where <column_name> in
(select <column_name>
from <table_name>
group by <column_name>
having count(*) > 1)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
The select into statement is most often used to create backup copies of tables or for archiving records?
What is crud diagram?
Does access use sql?
What is the purpose of the partition table?
How do you update a table in sql?
How many triggers can be applied to a table?
What is a left join?
What is the most important ddl statements in sql are?
What is using in sql?
What is the difference between clustered and non-clustered indexes?
How do you pronounce sql?
What is procedure function?
Enlist some predefined exceptions?
how to get @@error and @@rowcount at the same time? : Sql dba
What is the difference between sum and count in sql?
