MySQL Forums
Forum List  »  Newbie

Using a variable with LIMIT in SELECT statement
Posted by: CMS
Date: October 10, 2005 03:35PM

Is it possible, either directly or with a decent workaround to perform a LIMIT on a SELECT statement using a variable?

For example, I want the top N results, where N might be passed in to a stored procedure, or even issued from the command line...

SELECT * FROM `Candidate` LIMIT N;

This fails at 'LIMIT N' because, apparently, LIMIT has to be followed by a literal constant.

Is there a way to do this, or do I need to construct the SQL in my client and give up on using a stored procedure whenever I need a variable number of results?


Options: ReplyQuote

Written By
Using a variable with LIMIT in SELECT statement
October 10, 2005 03:35PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.