Eric Jain wrote: > > Is there any guarantee that rows are returned in the order they were > inserted, if no ORDER BY clause is given?
No. Even if there is no WHERE-part (not even in the view-definition if FROM <viewname> is given), then you cannot be sure to have this sequence (in case an index (with less pages needed for storing/reading) exists, which holds all the columns given in the select_list, this index can be used for selecting the rows --> sequence will differ) Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
