We have 100 records in table how to fetch 10 th record?
Answers were Sorted based on User's Feedback
Answer / buddula15
Using a normal SELECT statement, there is no provision to
specify a particular index number in the DB table for
fetching the required data. However, this can be done when
you are fetching data from an internal table.
Buddula
Is This Answer Correct ? | 16 Yes | 2 No |
Answer / rina patil
loop at itab.
if sy-tabix = 10.
read itab.
endif.
endloop.
Is This Answer Correct ? | 12 Yes | 4 No |
Answer / nilesh
The best method :
tables:LIKP.
select vbeln from likp into likp-vbeln .
if SY-DBCNT = 10.
exit.
endif.
endselect.
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / peednas
We Can Use Cursor To Get The 10Th Record from Data than
getting the table into internal table
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / moulika
data : begin of itab occurs 0 with header line,
f1,
f2 type i,
end of itab .
loop at itab.
if sy-tabix = 10.
write : itab-f1,itab-f2.
exit.
endif.
endloop
Is This Answer Correct ? | 1 Yes | 5 No |
Answer / victor
You can use the limit in mysql :)
SELECT * FROM table LIMIT 9, 1;
Is This Answer Correct ? | 0 Yes | 9 No |
what is the model dialog box?
1 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,
Can you define a field without a data element? : abap data dictionary
how to transport request give step/producer of transport request give step?
What is sap abap data classes?
three jobs are there if one fails wat happens?
How can a lock object be called in the transaction?
Give me the Full flow of SD and MM
Difference between sap script and report?
list the important field symbol?
Use SET PF_STATUS which is in the FM reuse_alv_grid_display to set the button
Is ABAP a GUI language?
In Interactive Report : How to come from Secondary List 10 to secondary list 4? what is the Program code?