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

how will you retrieve first record in table

Question Posted / saravana

Answer Posted / saravana

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

Is This Answer Correct ?

11 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Name the various locking levels available?

630

What is db2 look?

571

How do I create a view in db2?

597

What is the reason behind not using select * in embedded sql programs?

601

What is rct?

747

What is the physical storage length of the data types date, time, and timestamp?

600

What is ibm db2 used for?

596

How do I add a column to an existing table in db2?

587

Are view updateable?

627

How can you quickly find out the # of rows updated after an update statement?

626

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

637

How to restart a DB2 program?

1353

How is the value function used?

600

What is explain in db2?

582

How to rename a table in DB2 ?

635