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
- 8732 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
I am getting the (first) page number and the remaining records displayed in another list in another page BUT the PAGE Number is not displayed? What is the code/solution?
What are system variable in abap?
How many structures can be created in a Ztable ?
What is meant by hotspots?
What are the different function modules used in sapscript?
What are the main events of which are used for logical database?
What is the difference between a substructure and an append structure? : abap data dictionary
A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain?
What happens if only one of the commands set screen and leave screen is used without using the other?
What is database utility?
How do you find if a logical database exists for your program requirements?
Explain how many types of tables exist and what are they in data dictionary?
How do you work with semi colon se[arated files in BDC ?
Explain the difference between a pool table and a transparent table and how they are stored at the database level?
What are your ways to performance optimization?
