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

How to take backup of table in db2?

1021

How to execute stored procedure in db2 command editor?

984

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3520

What are packages in db2?

972

What is meant by dclgen?

1060

What is the default page size of buffer pools?

1070

When the like statement is used?

1156

what is utility for parm lib

2309

What are catalog tables in db2?

980

What is cloudant database?

1032

What is ibm db2 database?

951

How do you stop a db2 database in linux?

957

What types of tables are there in the db2 database?

1005

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1054

Why do we use cursor?

1048