In sequence i want to 11 and 15th values how we will write?
Answer / Nitin Gupta
To retrieve the 11th and 15th values from a sequential data set in Oracle, you can use SQL's row_number() function. Here's an example:
```sql
SELECT * FROM your_table
ORDER BY column_name
OFFSET (10-1) ROWS FETCH NEXT 2 ROWS ONLY;
```
In this example, replace 'your_table' with the name of your table and 'column_name' with the name of the column containing the sequential data. This query will return the 11th and 15th rows.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is trace file? what is the use of that?
what is the defference between credit memo and debit memo
What is GLOBAL TEMPORARY TABLE and It's significance ?
How to develop XML report without rdf?
what is fiscalcalendar?
what is tuning in oracle apps technical
Is it possible calling from one report to another? if possible means tell me ?
3 Answers Intelligroup, Satyam,
can we execute one concurrent program through another concurrent program?
what is difference between po_headers_all and po_headers
explain p2p cycle? what are the tables used for this?
is UOM maintained at master level or organization level or both?
What is a value set? List its various types.