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 reorg?

694


What is host variable?

683


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

701


What are the bind parameters ibm db2?

708


What is a storage group (stogroup)?

868






What is schema in db2?

666


What are the various data types available in db2?

711


How is a typical db2 batch pgm executed?

720


What is node in db2?

691


What is declare cursor?

706


What is a db2 collection?

688


What is copy pending and check pending in db2?

664


what are bind concepts in db2 cobol?

731


What are the 2 sqlcodes that are returned?

731


What is db2 bind?

710