Interested to Buy Any Domain ? << Click Here >> for more details...
how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 10112 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
Is schema the same as database?
What is the difference between cursor stability and repeatable read isolation levels?
What is copy pending and check pending in db2?
Which components manage deadlocks in db2?
What is buffer pool?
What is drop table?
What is the use of predicate?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Give the name of some fields form sqlca.
What is role in db2?
List out the three types of page locks that can be held.
Can we insert update delete in view?
What is the use of reorg in db2?
What do you mean by rollback?
What is multi row fetch in db2?
