Note that if you use ROWNO, then a following ORDER BY clause will sort only the records until the limit of ROWNO is reached. It says so in the manual at least, I haven't tried it... Makes the feature a bit useless IMO... You can set MaxDB to parse in Oracle mode and use ROWNUM to limit/offset..
Note to developers: It would be nice to see something similar to ROWNUM MaxDB's native language. I'm using the client to limit the output of the result. Cursors are supposedly slow (at least in many MS SQL articles I've read cursors are slow and one should only use them if absolutely necessary), don't know about MaxDB. Can anybody shed some light on this?) -Zavier ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 26, 2004 9:18 AM Subject: Re: How can I limit results from queries > select * from table where rowno<=[num of records that you need] > ej. > select * from table where rowno<=5 > > > > Grzegorz Konicki wrote: > > Hello > > > > How can I limit results from queries? > > > > In mysql or postgresql i use syntax limit, but in maxdb it doesn't work. > > > > > > > > --- > > Best regards Gregory > > > > > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
