select * from table_name; The above qurey get duplicate record also becaus

how to get duplicate records from tables?write qurey for this?

Question Posted / naresh k

4 Answers
9937 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

Please Help Members By Posting Answers For Below Questions

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1271

What language is db2 written in?

1047

How do I optimize a query in db2?

1101

What is buffer pool and list some of them?

1028

what are bind concepts in db2 cobol?

1092

How do I copy a table in db2?

1000

What is plan in cobol db2?

1138

Why select is not preferred in embedded sql programs?

1299

What is null indicator in db2?

1110

What is null in db2?

1024

What is a db2 tablespace?

1062

When reorg is used?

1127

What are concurrency issues?

1097

What are the bind parameters ibm db2?

1053

Is db2 a programming language?

1048