Interested to Buy Any Domain ? << Click Here >> for more details...
how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 9955 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 the cobol picture clause of the db2 data types date, time, timestamp?
How do I connect my db2 database to ibm?
Can you use max on a char column?
Explain about rct in db2?
what is the sqlcode -501
What is the syntax for FETCH in DB2 ?
How do I add a column in db2?
What is reorg and runstats in db2?
Where can you declare a cursor in a cobol-db2 program?
What is collection in db2 bind?
Why do chiropractors use drop table?
What is the use of with ur in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the use of reorg in db2?
How to execute stored procedures?
