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 |
How to run db2 command in windows?
What is the purpose of the WHENEVER statement?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
What is a cursor in programming?
What does CURRENTDATA option in bind indicate
What is the difference between drop table and delete table?
what is the use of commit ? and what is the syntax?
What is reorg and runstats in db2?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What are db2 objects?
What are the contents of a DCLGEN?
What is the difference between using bind () and rebind () methods of naming class?