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

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2869

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1103

Explain what are the various isolation levels possible?

991

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1005

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11618

How do I connect my db2 database to ibm?

988

How do I delete a column in db2?

1051

How to rename a table in DB2 ?

1033

How do I optimize a query in db2?

1042

What is check constraint. Explain with example.

1047

what is utility for parm lib

2311

What is cursor with hold option in db2?

1013

Name the various locking levels available?

1036

How to find the number of rows in db2 tables?

999

How to create backup table in db2?

1044