You can use the limit in mysql :) SELECT * FROM table LIMIT 9, 1;

We have 100 records in table how to fetch 10 th record?

Question Posted / victor

Answer Posted / victor

You can use the limit in mysql :)

SELECT * FROM table LIMIT 9, 1;

Is This Answer Correct ?

0 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Why do we use FOR ALL ENTRIES and what is the pre-requisite

1411

What is a table pool? : abap data dictionary

1079

Why do we use dynamic where conditions?

1438

when does a list get sent to the screen on the presentation layer?

1957

What abap statement will trigger list generation?

1077

how to see the table output?

2219

Which one is better joins or views and why?

1090

What is view? Different types of view.

1145

Reports: Event functionality.

1365

Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subrc after perform?

1108

Is it possible to pass data to and from include programs explicitly?

1020

What are multiple use BADIS?

1502

Can we create a gui status in a program from the object browser?

1201

What is the differrences between structure and table in data dictionary in abap? : abap hr

1211

What is alv programming in abap?

1143