We have 100 records in table how to fetch 10 th record?
Answers were Sorted based on User's Feedback
Answer / samir
u CAN SELECT USING THE SELECT STATEMENT INSIDE THE LOOP
UISNG THE INDEX. ALSO INCEASE THE INDEX BY ONE AS LOOP
INCREASES...
HOWEVER IT IS NOT ADVISIBLE TO WRITE SELECT INSIDE LOOP AS
IT AFFECTS PERFORMANCE.
Is This Answer Correct ? | 1 Yes | 12 No |
Answer / vimal
Select XXXXX
into table t_Rows
from YYYYYYY
up to 1 rows
order by XXXX descending.
XXXX---column name
YYYY---table name
For 'SELECT .... UP TO 1 ROWS' database selects all of the
relevant records that are defined by the WHERE clause or
lack of, applies any aggregate, ordering or grouping
functions to them and then returns the first record of the
resultant result set.
Is This Answer Correct ? | 2 Yes | 13 No |
diff way of handling errors in call trans ans session methods
why sapscripts are client dependent and smartforms are cliet independent,plz give me a brief explanation,thank u.
What is value table?
if u write a write statement after end of selection ,will that be triggered?
2 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,
Define structure in abap data dictionary?
In a loop of an internal table, what is the use of at first & at last statements?
How to debug a sapscript?
most commonly used command in Interactive Reporting?
How is conversion of data types done between abap/4 & external level?
can we transport text elements and text symblos in reports from devlopment to quality?is it necessary?
What are the function modules used in f4 help?
how do you display initial values in a selection screen?