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
8423 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 precompiler in db2?

954

What is a db2 schema?

1172

Can you use max on a char column?

1026

Which isolation level provides maximum concurrency?

1088

What is the maximum number of columns in a db2 table?

1210

What is db2 connect?

1006

What are the full forms of spufi and dclgen and why are they used?

1022

Explain the contention situations caused by locks?

1010

What is database manager in db2?

963

Is schema the same as database?

1003

What is the default page size of buffer pools?

1067

How do I copy a table in db2?

948

What is the syntax for seeing the columns and data types of a table in the db2 database?

1079

What is the maximum size of varchar data type in db2?

1063

What is bufferpool in db2?

983