Interested to Buy Any Domain ? << Click Here >> for more details...
please clear this what is the diff b/w select single * and
select up to 1 row?
- 5 Answers
- 8659 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What function does data dictionary perform?
Can you print decimals in type n?
Which type of tables used this buffer?
What is locking ?
How can an internal table with header line and one without header line bedistinguished when passed to a subroutine?
What are screen painter? Menu painter? Gui status?
How will you insert record in a sorted table
What are the aggregate objects in the dictionary? : abap data dictionary
What is sap locking?
Does every abap/4 have a modular structure? : abap modularization
What is the difference between semi-monthly and Bi-weekly payroll area
What is the difference between call transaction and session method? : abap bdc
What is the differences between abap and ooabap. In which situation we useooabap?
What was the requirement of IDoc in your project? How it was working?
How do we assign dynamic views while creating material master and generating bdc? : abap bdc
