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
- 51671 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / seshu
SELECT RNO,NAME,COUNT(*) REP_COL FROM Education GROUP BY
RNO,NAME having Count(*)>1;
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
How do I edit a stored procedure?
What are the disadvantages of not performing database normalization?
What are the differences between implicit and explicit cursors?
How do you drop a trigger?
What is the difference between having and a where in sql?
Is primary key clustered or nonclustered?
What is aggregate function in sql?
What is sql in java?
Can you have more than one key in a database?
What does t sql mean?
What can you do with pl sql?
Can we use joins in subquery?
What is materialized view. What are different methods of refresh?
how to convert character strings to dates? : Sql dba
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
