Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8732 Views
- I also Faced
- E-Mail Answers
Answer Posted / i go crazy
MADHURI IS CORRECT.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I create a view in db2?
How do I add a column in db2?
What is the default page size of buffer pools?
How will you return the number of records in table?
What is dbrm in db2 database?
What is runstats db2?
What are union and union all?
What is lock escalation in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is performance tuning db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is a bind in db2?
How can you do the explain of a dynamic sql statement?
What is the difference between using bind () and rebind () methods of naming class?
What happens in bind step in a db2 program?
