please clear this what is the diff b/w select single * and select up to 1 row?

Categories >> Software >> ERP CRM >> SAP >> SAP ABAP
Suggest New Category

please clear this what is the diff b/w select single * and
select up to 1 row?

Question Posted / madhuri

5 Answers
8753 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

please clear this what is the diff b/w select single * and select up to 1 row?..

Answer / ganesh

Using Select single * we can get exact record as we are using
primary key there,where as in Select up to 1 row,it will pick
first record from the selected records.if we forgot to opt for
primary keys in the where condition in select single then
it'll act like select single up to 1 row.

Is This Answer Correct ?

6 Yes

1 No

please clear this what is the diff b/w select single * and select up to 1 row?..

Answer / prasad

Select single * query will retrieve all the records from
the database table with respect to the condition specified
and finally select one single row among the retrieved.

In case of Select up to 1 row,the query starts retrieving
the database and once it gets the 1 row w.r.t its condition
it stops further retrieval.Performancewise using select
single * is not gud.

Is This Answer Correct ?

2 Yes

0 No

please clear this what is the diff b/w select single * and select up to 1 row?..

Answer / archana

select single is faster performence in comparision with
select upto 1 row.

Is This Answer Correct ?

1 Yes

0 No

please clear this what is the diff b/w select single * and select up to 1 row?..

Answer / g.shankar

if we have primary key as where condition we can go for
select single.select single is not a loop operation.

Is This Answer Correct ?

0 Yes

2 No

please clear this what is the diff b/w select single * and select up to 1 row?..

Answer / malli.gontla

select * from means, it completely retrieves all the data
from database table. it is not good for programming.

select up to 1 row means, it retrieves all the related
values for that query.From that result first row is selected.

Is This Answer Correct ?

0 Yes

7 No

Post New Answer

More SAP ABAP Interview Questions

tell me some of FI/CO tables

4 Answers FutureSoft,

1) If the scripts are client dependent, what above driver program ? (client dependent / independent) 2. I have two pages, In one page I want address, Header, Main & footer. In the second page I want only Main. How to do it? 3) Will 50,000 records be uploaded directly into APP's Server? 4) What is the button to change the variant in ALV ? 5) If your project is support project ? when is your implementation has completed ? 6)In start of selection, if we perform validation, what happens ? 7)How to join 3 tallies & looping. We have developed a program in a client say (200- client) and 210 has test data. No developing rights. How to test data? 8)How to transfer data which is coming from are report as output to another report 9)How to create standard text and how do u transfer it ? 10)What are the views when we are creating Material ?

1 Answers Deloitte,

What is the Process to transfer IDOC from Outbound System to Inbound system.

0 Answers

visibility section for class level and attributes level

0 Answers Infosys,

Give few names of transparent tables ?

1 Answers

What technical problem you will face if you create many secondary indexes.

2 Answers Deloitte,

What are the screen elements.

0 Answers

how many structures are in sap R/3(ABAP)

6 Answers Unilogic Software,

What is the difference between select statement and provide statement

1 Answers

What are the kinds of foreign key fields?

0 Answers

if i remove the select stmt from start-of-selection and put the select stmt in end-of-selection it is triggering then what is the use of start-of-selection? Please send me the answer

2 Answers Yash Technologies,

What are the two different ways of building a match code object?

0 Answers

For more SAP ABAP Interview Questions Click Here