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
- 8495 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
Which are the db2 tools to protect integrity of the database?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Why do chiropractors use drop table?
What is a db2 schema?
What's The Percentage Free Space ?
How many databases can be created inside an instance in db2 ?
How do you select a row using indexes in db2?
What is multi row fetch in db2?
What is rct?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What r the comman abends in db2, jcl and cobol???????
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What are iseries servers?
What is the meaning concurrency in the db2 database?
