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 |
What is DCLGEN?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
how do u update the faltfile into db2 table ?
How many databases can be created inside an instance in db2 ?
What will the COMMIT accomplish?
What is an instance in db2?
what is a plan and how do you refer the plan in the program?
Return code 100 means?
what is a collection?
Which one allows duplicate values Union or Union All ?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
How can you find out the # of rows updated after an update statement?