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
- 50856 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
What is time based sql injection?
what is the difference between sql and t-sql? : Transact sql
What is a rank in sql?
Which constraints we can use while creating database in sql?
Could you please provide oca (oracle 10g) dumps for my certification ?
Does truncate require commit?
What is a left join?
What is natural join in sql?
how many ways we can we find the current date using mysql? : Sql dba
how can we destroy the session, how can we unset the variable of a session? : Sql dba
How do I view a sql trace file?
how to concatenate two character strings? : Sql dba
How does one use sql*loader to load images, sound clips and documents? : aql loader
how to convert character strings to dates? : Sql dba
What are different types of functions in sql?
