select column_name,count(*) from table_name group by column

how to get duplicate records from tables?write qurey for this?

Question Posted / mahesh babu

Answer Posted / mahesh babu

select column_name,count(*) from table_name group by
column_name having count>1.

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

930

What does db2 plan contain?

752

What is declare cursor?

814

What is dbrm? When it will be created?

773

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

842

Explain the function of data manager.

807

Why select is not preferred in embedded sql programs?

926

How do I add a column in db2?

773

What is the cobol picture clause of the db2 data types date, time, timestamp?

831

what is a corelated subquerry?

828

How would you find out the total number of rows in a db2 table?

779

Can there be more than one cursor open for any program?

899

What is host variable in db2 cobol?

801

What are the prerogatives?

800

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2653