How to select the duplicate rows from a table?

Answer Posted / channabasappa

select field name from tablename where group by field name
having count(field name)>1;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which command is used to connect to a database in DB2 ? Give the Syntax.

689


Define check constraint.

721


what is a corelated subquerry?

738


What is buffer pool?

728


What is bufferpool in db2?

664






How many types of page locks can be held in db2?

689


What is runstats db2?

666


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

852


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1814


Is ibm db2 open source?

671


What is db2? Explain.

690


What is isolation level in db2?

655


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

705


Which isolation level provides maximum concurrency?

768


What are catalog tables in db2?

685