how will you retrieve first record in table

Question Posted / alluraj5

how will you retrieve first record in table..

Answer / saravana

select empname,empno from tablename order by empno fetch
first row only;

Is This Answer Correct ?

11 Yes

0 No

More DB2 Interview Questions

i have a db2 variable how do u declare tht into working storage section ?

what is the difference between declaring the cursor in WS section and Procedure division?

What is index in db2?

Differentiate between cs and rr isolation levels? Where do you specify them?

What is the difference between dbm cfg and db cfg file in db2 ?

How will you delete duplicate records from a table?

What is db2 plan table?

How to fetch the uncommited data from table ?

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

What is a system catalog table in db2?

how can we retrieve the 100 records of the file ?

How do I connect my db2 database to ibm?

For more DB2 Interview Questions Click Here