ROWNUM between 5 and 30 doesn't work
From: Sharron <sharron_allen_at_raytheon.com>
Date: Fri, 06 Jun 2003 15:43:08 -0700
Message-ID: <3EE118FC.1070908_at_raytheon.com>
Date: Fri, 06 Jun 2003 15:43:08 -0700
Message-ID: <3EE118FC.1070908_at_raytheon.com>
Hi, I can't seem to figure out how to get oracle to show rows other than
rows starting from 0 or 1. EX
SELECT * FROM users WHERE username != 'admin' ORDER BY name LIMIT 16, 20
//My sql statment that says start at row 16 and show 20 rows from there
How can I do this in ORACLE.
I've tried using ROWNUM but it only let's me start w/ row 0 or 1 never
2, 16, etc.
This won't work
SELECT * FROM users WHERE rownum < 22 and rownum > 3 and username != 'admin'
Please help.
Thanks