We have 100 records in table how to fetch 10 th record?
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 can we decide weather we can enhance the standard infotype or not ? : abap hr
the problem is that , while i am undergoing with my practice session, i am creating too many new programs.they are occupying much space in my hard-disk. how to delete un-necessary programs completely from my data- base........... plz help me with this .....
What is a type-pool?
What is the bapi?
What are the different types of the sap abap data dictionary objects?
What is is a match code? : abap data dictionary
What are the fields in the memory table ‘screen’?
What are ranges?
Can we define our own match code id's for sap matchcodes? : abap data dictionary
How is the command suppress-dialog useful?
What is a data class? : abap data dictionary
What are the basic objects of the data dictionary? : abap data dictionary
What is locking ?
What is the difference between a dialog program and a report?
How to Solve a Particular Ticket in Realtime ?