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
8890 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 is consistency token in db2?

1192

What is db2 instance?

1165

What is the use of reorg in db2?

1137

Is it possible using max on a char column?

1192

What is ibm db2 connect?

1054

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

1110

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

1232

What is difference between alias and synonym in db2?

1195

Is db2 a database?

1027

What are iseries servers?

1130

Is db2 a mainframe database?

1046

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3263

If I have a view which is a join of two or more tables, can this view be updateable?

1184

What is performance tuning db2?

1109

What type of database is db2?

1018