|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
Differences between SELECT SINGLE and UP TO 1 ROWS
by Sathiya Kumar
According to SAP Performance course the SELECT UP TO 1 ROWS is faster than
SELECT SINGLE because you are not using all the primary key fields.
Mainly: to read data from
The 'SELECT .... UP TO 1 ROWS' statement is subtly different. The database
selects all of the relevant records that are defined by the WHERE clause,
applies any aggregate, ordering or grouping functions to them and then returns
the first record of the result set.
Mainly: to check if entries exist.
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards