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

List out the three types of page locks that can be held.

689


What is a db2 collection?

605


When the like statement is used?

640


What are the rules for db2 programming?

641


What is db2?

741






What is db2 purescale?

549


What are host variables in db2?

626


How to find primary key of a table in db2?

613


Mention data types used in db2 ?

679


What is the function of logging in the db2 database?

645


What is the maximum length of sqlca?

869


How to check table size in db2 sap?

580


can all users have the privilage to use the sql statement select * (dml)?

642


What is the purpose of rollback and commit?

595


What is image copy in db2?

572