We have 100 records in table how to fetch 10 th record?
- 13 Answers
- 22793 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How are the function code handles in flow logic?
Some Realtime Examples on Exits .
What is function group?
Type casting and error handling
What is the difference between get and get late?
Give examples of transparent table?
When, how and how would you control changes to standard SAP objects.
What is the full form of spro? : sap abap hr
What are the difference between pool tables and transparent tables?
What are interface/conversion programs in SAP?
What is asynchronous and synchronous update?
What is the relationship existing between the various data elements? : abap data dictionary
What is the difference between the function module and a normal abap/4 subroutine? : abap modularization
How do you document abap/4 programs? Do you use program documentation menu option?
If I want to execute a program only in background not in foreground is there any option for this? : abap bdc
