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
- 43979 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mohan
select count(*),column_name from table_name group by
column_name having count(*)>1
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how to add a new column to an existing table in mysql? : Sql dba
Which kind of parameters cannot have a default value in pl sql?
How can I speed up sql query?
How can you fetch first 5 characters of the string?
When should I use nosql database?
What is left join in sql?
What does count (*) mean in sql?
What is an oracle stored procedure?
Explain constraints in sql?
What is nested table in pl sql?
When do we use triggers?
what is bcp? When is it used?
How do I use google cloud in sql?
Can a foreign key have a different name?
What is the maximum size of sqlite database?
