How to select the duplicate rows from a table?

Answer Posted / pandu

select distinct from <field name> from <table name>

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is image copy in db2?

566


What is declare cursor?

610


What are types of indexes?

591


What is dbrm? When it will be created?

595


Define declaration generator (dclgen).

665






what is utility for parm lib

1873


Explain package in db2 and its advantages?

593


What is the use of predicate?

582


What is a collection in db2?

579


What is role in db2?

614


What is the use of dclgen in db2?

588


What are catalog tables in db2?

604


What is the role of the data page in the db2 database?

585


Is db2 relational database?

572


How does db2 sample database connect?

566