how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 9143 Views
- ANZ, I also Faced
- E-Mail Answers
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 temporal table in db2?
What is bufferpool in db2?
How to find schema of a table in db2?
What is table space in db2?
What is copy pending and check pending in db2?
What is catalog database in db2?
What is ibm db2 connect?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Which component is responsible for db2 startup and shutdown?
What is reorg?
What does db2 plan contain?
What kind of database is db2?
What are union and union all?
Explain the function of data manager.
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
