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

Explain about open switch business continuity software?

1073

What is the latest version of ibm db2?

1201

Before you give the explain statement, what are the prerogatives?

969

Is db2 a mainframe?

968

What is the reason behind not using select * in embedded sql programs?

1044

What is reorg?

1071

What is the difference between drop table and delete table?

1117

Is schema the same as database?

1005

What is blu acceleration in db2?

1014

How to view db2 table structure?

960

What is the use of commit in db2?

1001

Why do chiropractors use drop table?

1044

Explain the function done by data manager?

1216

List down the data types in the db2 database.

1041

What is an instance database?

1005