without orders it is working, but if you have a order by in your select statement it won't return the wanted result.
We are working on tables with up to 4mio rows and getting results up to 10.000 rows. So it will be great if the SAPDB/MAXDB Developer will include such a feature like 'LIMIT' in MYSQL for future versions.
with best rgds.
Albert
Nick Chan schrieb:
Hello
I did a somewhat 'alternative' to MySQL Limit
(Selecting from number 11 to 20) from result set
SELECT NAME_ FROM
(SELECT NAME_ FROM SUPPLIER_ WHERE NAME_<'B' AND ROWNO<=20)
WHERE NAME_ NOT IN (SELECT NAME_ FROM SUPPLIER_ WHERE NAME_<'B' AND ROWNO<=10)
Is this efficient or any other 'faster' solution?
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
