How to select the duplicate rows from a table?

Answer Posted / channabasappa

select field name from tablename where group by field name
having count(field name)>1;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the function done by data manager?

1026


What is explain plan in db2?

765


What is the role of the data page in the db2 database?

768


What are the rules for db2 programming?

836


What is dclgen in db2?

874


what is a corelated subquerry?

825


What is rct?

966


Explain package in db2 and its advantages?

817


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

924


What do you mean by commit and rollback?

765


What is precompiler in db2?

759


How many types of page locks can be held in db2?

798


What kind of database is db2?

769


How to fetch the last row from the table in SQL (db2)?

1299


What is a cursor in programming?

806