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

Explain db2.

1039

What is sqlca?

1079

what is a corelated subquerry?

1122

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

1539

How to find primary key of a table in db2?

1066

What do you mean by cursor?

988

Which component is responsible for db2 startup and shutdown?

1036

What is the physical storage length of the data types date, time, and timestamp?

1090

How do I add a column to an existing table in db2?

1032

How to test SQL -911 error while developing COB-DB2 program

7575

List some fields from sqlca?

1060

How connect db2 database to datastage?

1244

What are host variables in db2?

1072

What is cursor with hold option in db2?

1075

What are the bind parameters ibm db2?

1053