robinson1983 Posted December 26, 2006 Share Posted December 26, 2006 hi guys .. How to select second row or third row of a table..I'm using oracle 9i.. Thanks in advanceregardssubin........ Link to comment Share on other sites More sharing options...
Reg Edit Posted January 2, 2007 Share Posted January 2, 2007 Dunno Oracle but how about this kind of thing? (Add the required ordering) select top 1 * from users where id not in (select top 1 id from users) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now