Skip to content

MySQLInterviewQuestions.com

MySQL Interview Questions and Answers

Home
Contact Us

How do you return the a hundred rows starting from 15th?

SELECT column_name FROM table_name LIMIT 15, 100.
The first number in LIMIT is the offset, the second is the number.

Share :

Click to print (Opens in new window)
Click to share on Reddit (Opens in new window)
Click to share on Tumblr (Opens in new window)
Click to share on Pocket (Opens in new window)
Click to share on LinkedIn (Opens in new window)
Click to share on Twitter (Opens in new window)
Click to share on Pinterest (Opens in new window)
Click to share on Facebook (Opens in new window)

Author adminPosted on May 2, 2013Tags limit, SELECT

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Notify me of follow-up comments by email.

Notify me of new posts by email.

Post navigation

Previous Previous post: how do you find out the unique values?

Next Next post: You want retrieve 10 results at a time, but at the same time you want to display total rows count?

Tags

Search for:

Top Posts & Pages

What is MySQL?

Recent Posts

What is MySQL?
Explain advantages of MyISAM over InnoDB?
How do you change a password for an existing user via mysqladmin?
Can you save your connection settings to a conf file?
What does tee command do in MySQL?

Home
Contact Us

MySQLInterviewQuestions.com Proudly powered by WordPress