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
- 51667 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sirisha
select id,count(id) from Education group by id having count(id)>1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
when MSQL8.0 is in market
how to include comments in sql statements? : Sql dba
Which is the correct statement about truncate and delete?
What program will open a mdb file?
define join and explain different type of joins? : Sql dba
What is oracle pl sql developer?
What are properties of the transaction?
How to set up sql*plus output format in oracle?
what are the different functions in sorting an array? : Sql dba
What is t sql in sql server?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
How many unique keys can a table have?
What are the differences between implicit and explicit cursors?
What is aggregate function in sql?
What is sql*loader and what is it used for? : aql loader
