Oracle limit clause
- Modify site almost functionally complete
- Looking into how to do what MySQL does with it's limit clause in Oracle
Oracle limit clause
Found this ugly workaround for MySQL's limit clause:
select * from ( select rownum as limit, t.* from ( select * from <table> where <condition> ) t) where limit between <lower limit> and <upper limit>
Hey it works....