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
8545 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 the usage of open cursor command?

1061

Mention some fields that are a part of sqlca.

997

Is db2 a database?

938

What is dbrm?

1069

Explain what are the various isolation levels possible?

1014

What is query_cache_limit?

943

What is a db2 tablespace?

1029

What is dpf in db2?

1074

define clustering index.

1000

what is db2 restart?

2119

How can you find out the # of rows updated after an update statement?

1090

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?

9093

What is a dbrm in db2?

984

How do I copy a table in db2?

978

What is a db2 schema?

1198