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
8667 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

Where do you specify them?

1265

What is db2 plan table?

1044

What are packages in db2?

1019

Define db2 and its databases?

1048

What is db2 catalog database?

1033

What is explain plan in db2?

981

How do you pull up a query which was previously saved in qmf?

1145

Is db2 a database?

955

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2837

How do you stop a db2 database in linux?

1006

What is bind package and plan in db2?

1049

What is db2?

1172

Why cursor is used in db2?

1031

What is the role of schema in the db2 database?

1264

what is db2 restart?

2147