Hmm Virender is correct

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

6 Answers
8701 Views
I also Faced
E-Mail Answers

Answer Posted / keshireddy

Hmm Virender is correct

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is meant by union and union all?

1012

Explain in detail about buffer manager and its functionalities?

1066

Explain package in db2 and its advantages?

1219

What is precompiler in db2?

1022

What are catalog tables in db2?

1050

What is the use of runstats in db2?

1110

What is null value in db2?

1026

How do I import a csv file into db2?

991

What is the role of data manager in the db2 database?

1109

What is the syntax for FETCH in DB2 ?

1213

What is difference between isnull and coalesce?

1056

What is the difference between dbm cfg and db cfg file in db2 ?

1536

What happens in bind step in a db2 program?

974

How would you find out the total number of rows in a db2 table?

1053

How many databases can be created inside an instance in db2 ?

1035