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
- 50667 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
What are functions in sql?
What is embedded sql what are its advantages?
how to create a new view in mysql? : Sql dba
what is a materialized view? : Sql dba
What is java sql driver?
Difference between table function and pipelined function?
What is numeric function sql?
Which command is used to delete a trigger?
What is the difference between Union and Union all. Which is faster.
What are the ddl commands?
what are different types of keys in sql?
What is package in pl sql with an examples?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
What is partition in sql query?
How do you rank data in sql?
