Skip to content

Substitute of LIMIT clause (as used in MySQL) in O…

No comments and 9 views

Posted in Database, Technology.

Substitute of LIMIT clause (as used in MySQL) in Oracle:

SELECT COL_NAME (SELECT COL_NAME, ROWNUM r from TABLE_NAME) WHERE r BETWEEN 10 AND 15

It will select 6 rows (10th to 15th inclusive)

Note from Author :
I maintain my website, write articles and reply comments because of my interest/hobby to share information and knowledge.

If you liked the post, Please
Follow me on twitter: http://twitter.com/pankajbatracom
Join My facebook page: http://www.facebook.com/pankajbatra.blog
Join me on LinkedIn: http://www.linkedin.com/in/batrapankaj
Or subscribe to updates by Email by clicking here

To subscribe for updates, Enter your email address:

Related posts:

  1. Facebook Email in response to Google Gmail Buzz
  2. Selecting random rows from an oracle table
  3. Email Marketing Tool Application

By Pankaj Batra – July 3, 2007

0 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.







Some HTML is OK

or, reply to this post via trackback.

« »