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

What is coalesce in db2?

1139

Mention the definition of cobol in varchar field.

1250

What is the difference between cursor stability and repeatable read isolation levels?

1182

i want to maintain uniqueness on pdf without make lf??????????

2158

What is db2 catalog database?

1050

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

1052

How to find the maximum value in a column in the db2 database?

1084

What is the syntax for FETCH in DB2 ?

1222

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1090

What is the max length of sqlca?

1221

What are the different types of base tables?

1100

What are the benefits of using the db2 database?

1235

How do you eliminate duplicate values in db2?

1201

Explain the function of data manager.

1050

How will you return the number of records in table?

944