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?
- 6 Answers
- 6678 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
List out the data types available.
How do you pull up a query which was previously saved in qmf?
What is null indicator in cobol db2?
Mention some fields that are a part of sqlca.
How many databases are there?
Are views updateable?
What are db2 tables?
What is image copy in db2?
Explain dclgen.
define clustering index.
How does db2 sample database connect?
What type of database is db2?
What is difference between isnull and coalesce?
What is collection in db2 bind?
What is data manager?
