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

Plan has the optimized access path in it. But is that optimized access path is attained or known

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

What is a view? Why use it?

What is package in cobol db2?

How could one combine a set of incremental image copies into a single copy?

What is QUIESCE?

how to execute qcmdexc in rpgle?plz write code also?

What action db2 takes when a program aborts in the middle of a transaction?

Name some fields from SQLCA.

Where can you declare a cursor in a cobol-db2 program?

What are column-name qualifiers used?

What's the maximum number of volumes that can be added to a STOGROUP?

For more DB2 Interview Questions Click Here