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....