how to get duplicate records from tables?write qurey for this?
Answer Posted / naresh k
select * from table_name;
The above qurey get duplicate record also because the
database store records like multi-set..
if we want get distinct records then use following query.
select distinct(attribute_name) from table name
Is This Answer Correct ? | 0 Yes | 15 No |
Post New Answer View All Answers
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is alias in db2?
Define check constraint.
Explain the contention situations caused by locks?
what is the responsibility of the construction superintendent
What is bind in db2?
Explain the benefits you can get from mainframe connect?
What is the maximum length of sqlca?
Explain package in db2 and its advantages?
Define data page.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What are the contents of a dclmgen?
How many databases are there?
What is a dbrm in db2?