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

How do I import a csv file into db2?

739


What is a db2 cursor?

797


How can deadlocks be resolved?

725


What is a Foreign Key?

851


What is netezza database?

768


What is declare cursor?

813


How many databases can be created inside an instance in db2 ?

806


How do I connect my db2 database to ibm?

788


How to execute stored procedure in db2 command editor?

734


What is database reorganization?

824


What is dbrm in db2 database?

784


What is the max length of sqlca?

959


What is db2 stogroup?

882


What are the 2 sqlcodes that are returned?

853


What is concurrency?

902