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 does runstats do in db2?

607

Explain dclgen.

722

What is the difference between bind and rebind in db2?

848

List out the data types available.

700

Is db2 relational database?

572

What is load replace in db2?

560

Is db2 a mainframe?

583

What os does db2 run on?

570

Define buffer pool.

625

Is schema the same as database?

627

what is db2 restart?

1690

Name the lockable units in DB2?

663

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

1035

What is the picture clause of null indicator variable?

688

Mention the different locking levels that are available in db2.

643