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
- 51137 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / satheesh
SELECT * FROM EDUCATION E1 WHERE ROWID>(SELECT MIN(ROWID)
FROM EDUCATION E2 WHERE E1.EMPID=E2.EMPID)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does asenumerable execute the query?
what are the different functions in sorting an array? : Sql dba
How do I start sql profiler?
what is rdbms? : Sql dba
How does pl sql work?
What is sqlcommand?
How to run sql statements through the web interface?
Are stored procedures faster than queries?
What are stuff and replace function?
Write a sql query to get the third highest salary of an employee from employee_table?
What are primary key and foreign key and how they work?
What is sap sql?
How to combine two stored procedures in sql?
What does t sql mean?
What is trigger price?
