adspace
In sequence i want to 11 and 15th values how we will write?
Answer Posted / 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 |
Post New Answer View All Answers
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Plz anybody send me Technical specification for AP Interface
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify