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


Please Help Members By Posting Answers For Below Questions

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2462


Plz anybody send me Technical specification for AP Interface

2634


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2690


pls send me out bound code of supplers,site,bankiformation code pls as soon as

2347


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

2119