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.

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.

Answer / archana

select single is faster performence in comparision with
select upto 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.

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.

What is user specific parameter?

2 Answers  

What are the different control break statements available inside a loop?

0 Answers  

Difference between transparent tables and pooled tables? : abap hr

0 Answers  

Suppose I am working on userexit if someone wants to work on same is it possible to work?

2 Answers   NTT Data,

Give few names of cluster tables in sap ?

1 Answers  

what is the table name of stock of material

4 Answers   TCS,

control break statements in ABAP?

10 Answers   TCS,

What is the transaction code to display the payroll results

2 Answers  

which is procedure used for SAP Enhancement?

2 Answers  

How many lists can a program can produce?

0 Answers  

What are the different types joins?

0 Answers  

How can you change the style of Logo or type of Logo?

1 Answers