How to select the duplicate rows from a table?

Answer Posted / nans

Select FIELD1 From <TABLENAME> As Temp Group By FIELD1 Having
Count(*) >1;

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When the like statement is used?

640


Explain the function done by data manager?

857


When do you specify the isolation level?

608


How do I import a csv file into db2?

560


What is cloudant database?

643






How can you classify the locks in db2?

636


How can the duplicate values be eliminated from db2 select?

631


Give the name of some fields form sqlca.

614


Explain package in db2 and its advantages?

597


What is lock escalation in db2?

574


What is isolation level in db2?

577


What is multi row fetch in db2?

607


How to check sequence on a table in db2?

600


What is null indicator in cobol db2?

585


What is null indicator in db2?

604