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 use of help view?how can we create search help for a field?in how many ways we can give search help?
What are the differences between a database index and a match code? : abap data dictionary
What is the tcode to create indexes?
in which table idocs are stored?
three jobs are there if one fails wat happens?
Can we develop program without logical database for hr module data retrieval
what is the transaction code for asset master transaction
What are different types of parameters?
What are the ABAP commands that link to a layout set?
what is 'F4' functionality?
how top handle error in LSMW?
What is an abap dictionary?