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 / abhilash

6 Answers
8709 Views
I also Faced
E-Mail Answers

Answer Posted / abhilash

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is query_cache_limit?

971

what is diffrence b/w file-aid tool and file-aid utility???

4892

What do you mean by storage group (stogroup)?

1041

How is the value function used?

1157

What is db2? Explain.

1044

What is lock escalation in db2?

1033

How and when does the db2 enforces the unique key?

1083

Is it possible using max on a char column?

1141

What is the use of runstats in db2?

1112

Is db2 a mainframe?

1044

What is difference between alias and synonym in db2?

1143

What is the difference between spufi and qmf?

1134

What is with ur in db2?

1320

Which isolation level provides maximum concurrency?

1152

What is the use of dclgen in db2?

1085