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 |
write the program for prime numbers between 1 to 1000
Events in Interactive reporting?
what is Composite key in table creation? what is the use?
3. What is table maintaince generator ? How do u do it ? Use of it ?
What are the steps to be followed to set lockobjects? : sap abap data dictionary
what type of error will be seeing in the log file in SM35
How can we upload a text file having delimiters in to legacy system? : abap bdc
HI ALL!HOW CAN WE SEND SMS THROUGH SAP ECC5 (NOT THROUGH ECC6)???ANY BODY KNOW THOSE PROCEDURE KY GIVE REPLY.....
What is screen flow logic? What are the sections in it?
What is field catalog. Describe the purpose of it?
Can you call a bdc from a report program ?
What are the steps in creating screen ?