Re: equivalent to LIMIT?

Brian wrote: > Was wondering if there's an Informix equivalent to the LIMIT clause seen > in MySQL and PostgreSQL (and possibly others)? > Right now, if our devs need rows 400-450 in a 10,000 row table, they > SELECT TOP 450, but that just seems inefficient especially when you get > to returning 10k rows when you only need the last 50. What is it you are trying to do? What sort of query filters out 450 rows, and then says I only want to see the last 50? What ARE the LAST 50, as it would depend on the order. Can't you modify your filter to return just the 50 you actually want? Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list