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

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

What is a LIKE table and how is it created?

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

where can we use index and subscript ? with example ?

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

What types of tables are there in the db2 database?

What are some characteristics of columns that benefit from indexes?

What are the abend codes occour in ur latest PROJECT in DB2

What is difference between alias and synonym in db2?

What are the contents of dclgen?

What is PRIME TABLE and what are the uses of it

What is meant by repeatable read?

For more DB2 Interview Questions Click Here