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 the advantage in De-normalizing tables in DB2?
How can deadlocks be resolved?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Define buffer pool.
What is the syntax for seeing the columns and data types of a table in the db2 database?
List out the data types available.
How to check table size in db2 sap?
What is a db2 package?
What is db2 purescale?
How to find the number of rows in db2 tables?
Can we insert update delete in view?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What r the comman abends in db2, jcl and cobol???????
What are the different types of base tables?
can all users have the privilage to use the sql statement select * (dml)?