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 load utility in db2?

1126

Can one database have multiple instances?

1004

How to connect to db2 database from windows command line?

999

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

1014

Explain package in db2 and its advantages?

1133

What is a page in db2?

979

How to create backup table in db2?

1041

What is plan in cobol db2?

1057

What is the difference between oracle and db2?

1028

List some fields from sqlca?

1000

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

1048

What is database alias db2?

1065

What is difference between isnull and coalesce?

1005

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2778

What are bind parameters in db2?

979