Hello I have a problem with clause "order" My query looks like: select * from (select company,rowno as row from clients order by company) where row >1 and row < 100
and MaxDB return me an error : missing delimiter ) Is it possible to use clause "order by" in inner select? How can i do this.I want to order first and next limit the result. best regards gregory -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
