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
- 47211 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kalaiselvan.j
select count(*),column_name from table_name group by
column_name having count(*)>1
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
Can we create clustered index without primary key?
Differentiate between pl/sql and sql?
how can you create an empty table from an existing table? : Sql dba
What is the difference between drop and truncate commands?
Do we need commit after truncate?
what is user defined functions? : Sql dba
Can you do multiple joins in sql?
describe transaction-safe table types in mysql : sql dba
what does the t-sql command ident_current does? : Transact sql
How to run sql statements through the web interface?
How to display Row Number with Records in Oracle SQL Plus?
What are all different types of collation sensitivity?
Can we use commit inside a trigger?
what is the different between now() and current_date()? : Sql dba
What is the location of pre_defined_functions.
