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?

Reply via email to