Interested to Buy Any Domain ? << Click Here >> for more details...
We have 100 records in table how to fetch 10 th record?
- 13 Answers
- 25605 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
write a program for creation of customer quotation using BAPI 'BAPI_QUOTATION_CREATEFROMDATA'.
How to create user interfaces for lists?
Fallback class
What are the types of indexes in abap?
HOW CAN YOU USE A PAGE COUNT IN CALLING A PAGE IN SMARTFORM?
What is filter dependent BADI?
What are system variable in abap?
What are logical databases? What are the advantages of logical databases?
Double click function on the lists, identifying the line selected by the user on the list?
What are the different database integrities?
Hi every one ! You people are doing a great job here , Im going to attend Tata Technologies interivew on this sunday,Can anyone who has already attended this company interivew or other companies interivews in abap pls share ur experience with me and help me to get into job my id ushareddyabap@gmail.com. Thankyou verymcuh
What is lock mechanism? How do we create lock objects in abap?
What is meant by search help? : sap abap data dictionary
Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul
Explain the uses of the simple maintenance interface? : sap abap hr
