Select FIELD1 From <TABLENAME> As Temp Group By FIELD1 Having Count

How to select the duplicate rows from a table?

Question Posted / nans

Answer Posted / nans

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

Is This Answer Correct ?

14 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is dbrm in db2 database?

1052

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2800

What is the difference between spufi and qmf?

1069

Which isolation level provides maximum concurrency?

1107

What is the use of db2?

1015

What is ibm db2 client?

890

Explain in detail about buffer manager and its functionalities?

1020

What does runstats do in db2?

1041

What parameters are used to control the free space in DB2?

1021

What is the difference between db2 and oracle?

1077

What are the various isolation levels possible?

1061

What is data manager?

1002

define clustering index.

988

What is db2?

1135

List down the data types in the db2 database.

1054