select * from <itab> upto 1 row.

In an Internal Table, I have 1000 records. I have to
Retrieve One Record. In Performence wise what is the Best
Query?

Question Posted / nyk

Answer Posted / nyk

select *
from <itab>
upto 1 row.

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

send coding to write a program to create customer quotation using BAPI 'BAPI_QUOTATION_CREATEFROMDATA2/BAPI_QUOTATION_CREATEFR OMDATA'

2780

What are the update types possible?

1046

How move-corresponding works

1329

How do you display a data in a detail list?

944

Define infotype ? : abap hr

1199

Can we create field without data element? If yes, how?

1095

What is its? : abap hr

1002

How can we set the tablespaces and extent sizes ?

945

How to display or know if the value entered contains records or not?

959

how to use table control?if suppose i have 6 records and i want more 4 records in sequence.How to handle this scenario?

1985

What are the parameters used in each function?

989

Explain the Types of Select statements?

1033

How many types of views are there? : abap data dictionary

988

What are the function modules used in a sap script driver program?

1087

The extract statements in field groups can be used before or after processing the sort statements. State true or false. : abap modularization

981