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
8661 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 are packages in db2?

1019

When do you specify the isolation level?

1024

What is db2? Explain.

1034

What is a plan and package in db2?

1091

What is a Foreign Key?

1090

What is difference between isnull and coalesce?

1051

How to retrieve rows from a db2 table in embedded sql?

1378

What are the contents of a dclmgen?

1117

Is db2 a mainframe database?

991

what are bind concepts in db2 cobol?

1085

Why select is not preferred in embedded sql programs?

1290

What is the maximum size of a char data type in db2?

1004

What is db2 and what is the use of db2 optimizer?

1049

Which component is used to execute the sql statements?

1089

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1096