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
Can i know some of the Realtime tickets that anyone has been faced ?
How to find the return code of a statement in abap programs?
Abstract class and interface, multiple inheritance, live example
If A is the super class of B. And both the classes have constructor. We create an object of class B. Then which constructor will be called? If both then in which order?
What is the function of the transport system and workbench organiser?
What are the data types of the external layer? : abap data dictionary
Cds views
What is a multiple line field? : abap bdc
What are the basic objects of the data dictionary? : abap data dictionary
What are client dependent objects in abap/sap?
Explain how many types of tables exist and what are they in data dictionary?
what is diff between ECC 5.0 AND ECC 6.0
What is the bapi?
What are the differences between structure and table in data dictionary in abap? : sap abap data dictionary
Give an example of interface from your project explaining why you used it?