SELECT(*) Will return 10 and SELECT (distinct dept) will return 8.

If a table has a column "dept" (declared to have nulls) and
there are 10 rows in the table of which 3 have a null value
in the dept column, what will select count(*) and select
count(distinct dept) return?

Question Posted / virender

6 Answers
8733 Views
I also Faced
E-Mail Answers

Answer Posted / virender

SELECT(*) Will return 10 and SELECT (distinct dept) will
return 8.

Is This Answer Correct ?

7 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a storage group (stogroup)?

1253

What is with ur in db2?

1331

What is the maximum No of rows per page?

1076

What is rebind in db2?

1073

List out the buffer pools in db2

1080

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9232

What is copy pending and check pending in db2?

1008

Explain about cursor stability?

1060

What is schema in db2?

1027

What is deadlock in db2?

1076

What are iseries servers?

1084

What happens in bind step in a db2 program?

979

How does a cursor work?

994

How do I copy a table in db2?

1008

Why do we need reorg in db2?

998