Answer / vijeta

You can use UPTO 10 ROWS in your select query

Answer / samir

u CAN SELECT USING THE SELECT STATEMENT INSIDE THE LOOP
UISNG THE INDEX. ALSO INCEASE THE INDEX BY ONE AS LOOP
INCREASES...
HOWEVER IT IS NOT ADVISIBLE TO WRITE SELECT INSIDE LOOP AS
IT AFFECTS PERFORMANCE.

Answer / 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 it possible to insert records into structure? if yes means how many records can be inserted?

2 Answers  

---

Hi, I have 100 records in a table, how to read every 7Th record each in that...

3 Answers   Infosys, TCS,

---

How can I make a differentiation between dependent and independent data?

2 Answers  

---

What is the client concept in sap?

0 Answers  

---

what is the difference between session ,call Transaction?

3 Answers   Accenture, LGS,

---

What is Macro

2 Answers   IBM,

---

What is step-loop? Explain all the steps?

0 Answers  

---

How is batch input process different from processing online?

1 Answers  

---

can we fetch data , when we write a select query under end - of - selection event.

2 Answers   CTS,

---

i have a requirement.there are 2 fields and one check box on my selection screen.initially first field sud be mandatory, when we click on check box the first field which was mandatory sud now be optional and second field sud be mandatory?please provide me the solution asap.Thank you

1 Answers   IBM,

---

How to process the session dynamically?

2 Answers   Cap Gemini,

---

What are pooled tables? : abap data dictionary

0 Answers  

---