Answer Posted / nak
No,Count(*) will give u the number of record in a table.
Ex: select Count(*) from EMP table where EMPNAME='sunil'
Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is runstats and reorg in db2?
How does cobol compile db2 program?
Which component is responsible for processing sql statements and selecting access paths?
What is consistency token in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What are union and union all?
On which levels locks can be applied?
What is bind in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What are iseries servers?
What are the prerogatives?
Can we insert update delete in view?
Mention the location where the output received from explain statement is stored.
Is db2 a programming language?
What is db2 and what is the use of db2 optimizer?