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.

check sy-subrc = 0 and if sy-subrc =0 difference explian

1 Answers   IBM, VSoft,

---

WHAT IS FIELD-SYMBOLS?

2 Answers   Sony,

---

Suppose, we are creating one table. at that time we are mention table space and size category. Generally size category is from 0 to 6 is available. suppose if we are declare size category as 0(zero). For 0 (zero) the size of rows is from 0(zero) to 19000. I have 25000 records to insert into table. but table size is declared as 0(zero). i.e 19000 records. what about remaining 6000 records. shall i insert in to table or not? if insert how can i do? if not insert what can i do? Please answer me? i faced this one in TCS interview.

2 Answers   TCS,

---

SAP modifications and enhancements stored in which table?

1 Answers  

---

What is the use of dequeue function module? : sap abap data dictionary

0 Answers  

---

---

where do we define LDB to a program ?

1 Answers  

---

How can we call, call transaction and session method in the same program?

3 Answers   Cap Gemini,

---

I have 2 fields like customer and name having 20 records on basic list. when i select 5 records randomly, i want to get the address of particular customer selected in secondary list

1 Answers  

---

what are the advantages and disadvantages in LSMW over BDC?

1 Answers   IBM,

---

What is For-period and In-period

1 Answers  

---

what is search help exit ????

0 Answers  

---

will sorted internal tables help in performance?

2 Answers   IBM,

---