Answer / manu gowdru

select single:it selects the first record which matches the condition defined in WHERE clause.so if there many records which matches the criteria will be ignored,so its not unique

select upto 1 rows:it retrieves all the records which matches the condition mentioned in WHERE clause and puts aggregate,average and gives the result

Answer / sumit0312

select single fetch the specified and matching data from the
table. and select up to 1 record directly select the first
record from the tabe.

Answer / silverage

Both will fetch 1 record from table. Select single is used when all the key of the table are to be matched in where condition. Select upto is used when any of the key is missing in the where condition.

Answer / nigesh

Select Single * will pickup only one matching record from
the database into the buffer, and returns the same to the
internal table.

Select upto 1 rows will pickup all the records matching the
condition into the buffer, but return the top record to the
internal table.

Answer / gagan

in select single , if multiple records are present matching
the where clause ( if stated ), then it returns the last
record among them.

While in select upto 1 rows , it returns the first
occurrence of the record.

Lock objects and what are parameters of ENQUEUE FM?

0 Answers   Infosys,

how to transport abap workbench objects

2 Answers  

In real time how we get the tickets? whether it is through email or any thing else.

1 Answers  

Explain V2 updates

1 Answers  

What are the aggregate objects in the dictionary? : abap data dictionary

0 Answers  

What will happen when we use fully buffered in abap?

0 Answers  

Some one is running a program in Foreground which has to be run in Back ground. How you are going to instruct to do in Back ground?

1 Answers  

What is a batch input session?

3 Answers  

which method is suitable for call transaction asynchronous or synchronous

1 Answers  

Explain the differences between interactive and drill down reports?

0 Answers  

how to print barcode in vertical manner

1 Answers   CSC,

What are control break statements?

19 Answers   Cap Gemini, College School Exams Tests, Keane India Ltd, Wipro,