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
What is package in db2 mainframe?
What is db2 look?
How can deadlocks be resolved?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Describe major components of db2?
What is the maximum length of sqlca?
What is meant by dclgen?
What is the maximum size of a char data type in db2?
Explain the benefits you can get from mainframe connect?
What are the 2 sqlcodes that are returned?
What is host variable?
What is scrollable cursor in db2?
What is a db2 schema?
What is dbrm? What it contains? When it will be created?
How does coalesce work?