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

6 Answers
8508 Views
I also Faced
E-Mail Answers

Answer Posted / abhilash

SELECT(*) Will return 10 and SELECT (distinct dept) will
return 8.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What r the comman abends in db2, jcl and cobol???????

2220

What is the advantage in De-normalizing tables in DB2?

1136

List some fields from sqlca?

1016

What is phantom read in db2?

1092

How to find the number of rows in a db2 table?

1086

How connect db2 database to datastage?

1198

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

987

Give a brief description of db2 isolation levels?

1029

What is db2? Explain.

1000

Can you use max on a char column?

1052

List out the buffer pools in db2

1041

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1129

What is the picture clause of null indicator variable?

1095

Can we update view in db2?

954

What is table space in db2?

977