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 are write I/Os from the buffer pool executed?
What is dbrm? What it contains?
How to find primary key of a table in db2?
Is db2 a programming language?
When Can you be sure that a query will return only one row?
How many buffer pools are available in db2?
can you use symbolic parameters in JOB?
What keyword does an SQL SELECT statement use for a string search?
Explain various types of locks in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
what is sql abend code -801,-802?
Explain about dbrm.