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
8768 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