topic Re: Question in open SQL for Ztable in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/question-in-open-sql-for-ztable/m-p/3386745#M813172 <HTML><HEAD></HEAD><BODY><P>The order in which data is returned is not guaranteed uless you specify an order. Try :</P><P></P><PRE><CODE>SELECT * FROM zxxx UP TO 1 ROWS WHERE type = '01' ORDER BY zz_field DESCENDING. ENDSELECT. </CODE></PRE><P></P><P>Rob</P></BODY></HTML> Tue, 19 Feb 2008 17:10:38 GMT Former Member 2008-02-19T17:10:38Z Question in open SQL for Ztable https://community.sap.com/t5/application-development-and-automation-discussions/question-in-open-sql-for-ztable/m-p/3386744#M813171 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P> I have a Z table and there is SQL that get's the latest record from the Ztable.</P><P></P><P>SELECT * FROM ZXXX WHERE TYPE = '01'. ENDSELECT.</P><P></P><P>For example there is a column called template in this Z table whose 1st record has value 100001 and last record has value 100029. Yesterday the SQL above was getting the latest record for example 100029 and today I run the same SQL and it is not getting the latest record!! It get's some other record from the middle for example with value 10001! Is there any reason why this behavior happens? Any suggestions please..</P><P></P><P>Thanks.</P><P>Mithun</P></BODY></HTML> Tue, 19 Feb 2008 16:51:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/question-in-open-sql-for-ztable/m-p/3386744#M813171 Former Member 2008-02-19T16:51:28Z Re: Question in open SQL for Ztable https://community.sap.com/t5/application-development-and-automation-discussions/question-in-open-sql-for-ztable/m-p/3386745#M813172 <HTML><HEAD></HEAD><BODY><P>The order in which data is returned is not guaranteed uless you specify an order. Try :</P><P></P><PRE><CODE>SELECT * FROM zxxx UP TO 1 ROWS WHERE type = '01' ORDER BY zz_field DESCENDING. ENDSELECT. </CODE></PRE><P></P><P>Rob</P></BODY></HTML> Tue, 19 Feb 2008 17:10:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/question-in-open-sql-for-ztable/m-p/3386745#M813172 Former Member 2008-02-19T17:10:38Z