Interested to Buy Any Domain ? << Click Here >> for more details...
We have 100 records in table how to fetch 10 th record?
- 13 Answers
- 25526 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
What are the different types of the sap abap data dictionary objects?
What are advantages and disadvantages of logical data base
What is time constraint ? : abap hr
What are the types of data types in the sap abap?
Can we handle two transaction codes in the same program using call transaction bdc input method? : abap bdc
How do we assign dynamic views while creating material master and generating bdc? : abap bdc
What are the dynamic actions and how to configure it? : sap abap hr
Name the special commands of list?
What are null values?
What is payroll driver ? : abap hr
How do you find if a logical database exists for your program requirements?
It is possible to assign a local data object defined in a subroutine or function module to a field group. State true or false. : abap modularization
What does nw 7.4 sp 05/nw 7.5 sp 02 offers in abap?
hi,how to diable the popup window which is displayed afetr executing the SAP script program?
Performance tuning techniques
