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 are bind parameters in db2?

788


What is null value in db2?

750


How to get the ddl of a table in db2?

857


Which isolation level provides highest data integrity?

807


What is the difference between cursor stability and repeatable read isolation levels?

900


What are the two types of logging in the db2 database? Explain them.

787


What is the syntax for FETCH in DB2 ?

898


Discuss about db2 bind?

859


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1790


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

846


What is difference between isnull and coalesce?

794


What is the difference between plan and package in db2?

823


How to find the number of rows in a db2 table?

842


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

814


How can the duplicate values be eliminated from db2 select?

850