OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Antwort: Ways to do limit clause

Tom.Zschockeltflender.com
Date: Tue Sep 21 2004 - 06:13:33 CDT

Yes there is a way,

SELECT * FROM users WHERE ROWNO < 10 ORDER BY username

look at the reference manual

greetings

tom

Stefano Ghezzi <stefano.ghezziicteam.it>
21.09.2004 13:08

 
        An: maxdblists.mysql.com
        Kopie:
        Thema: Ways to do limit clause

In MySql there is the limit clause
that let you do something like

SELECT * FROM users ORDER BY username LIMIT 10,20

Is there any way to do the same stuff in maxdb?

thanks in advance

--

____________________________________________________________
Stefano Ghezzi ICTeam S.p.A
tel 035 4232129 fax 035 4522034
email stefano.ghezziicteam.it aim://stefanoghezzzi
mobile 335 7308587 url http://www.icteam.com
____________________________________________________________

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=tom.zschockeltflender.com