Interested to Buy Any Domain ? << Click Here >> for more details...
We have 100 records in table how to fetch 10 th record?
- 13 Answers
- 26048 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
Explain what is the difference between primary key and unique key?
Explain the data types of internal tables?
What are local objects?
i have executed a report via back ground job, in this report i have used enqueue and dequeue function modules on a table, but before releasing the lock(before dequeue function module is not call) job gives the dump, so the lock is not released the table, here my question is how to set the lock automatically release the there is a short dump before calling the dequeue module?
Define batch input session?
When you prefer lsmw?
Which infotype records can not be deleted ? : abap hr
What is sap luw or update transaction?
If I forgot some command in sap script e.g.: Suppress zero display – how to do find it?
What’s value table?
What is the difference between a structure and a table?
What are field symbols and field groups? Have you used component idx of structure clause with field groups?
Define infotype ? : abap hr
Can matchcode object contain ids with different update types? : abap data dictionary
Differentiate screen painter from menu painter.
