What is the purpose of coding FETCH in a SQL SELECT query?
Explain with an example in Detail?
- 4 Answers
- 6779 Views
- I also Faced
- E-Mail Answers
Answer Posted / siri reddy
Inorder to select first n number of rows fetch is used in
conjunction with select statement
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to find the number of rows in a db2 table?
What is a trigger in the db2 database?
Mention some fields that are a part of sqlca.
How to take backup of table in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is null in db2?
How to get the ddl of a table in db2?
What is the picture clause of null indicator variable?
What is nvl 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?
Is db2 a database?
What is the role of union all and union
Explain about cursor stability?
How to create db2 table in mainframe?
How do you find the maximum value in a column in db2?
