Interested to Buy Any Domain ? << Click Here >> for more details...
how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 9920 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 a db2 schema?
How can deadlocks be resolved?
Mention the downsides of page level lock.
What is the use of db2 optimizer?
How to find the number of rows in db2 tables?
What is data manager?
What is the role of schema in the db2 database?
What is a buffer in memory?
What is commit in db2?
What are the full forms of spufi and dclgen and why are they used?
How many types of page locks can be held in db2?
What is db2 connect?
What is buffer pool in the db2 database?
What is bind plan?
What are the different types of base tables?
