Setting limit using another query

[computerzworld]

Hello,
I want to set the limit of one query using another query. What's the syntax of it? Here is the way that I 've tried...

select * from mytable limit (select limit from othertable)

But it didn't worked.So what's the right syntax to set the limit using another query? Please help me. Thanks in advance.

[bradgrafelman]

I don't think there is a way to use a value from a SQL result as the parameter in a LIMIT clause.

Instead, you'll probably have to look into using a stored procedure so that you can define a variable, store the "limit" value from the other table into this variable, and then use the variable in the LIMIT clause of the second query.

[computerzworld]

Yes that's right. It also can be done by using the query separately and getting its result in variable and using that variable after the limit but what I am asking is that is it possible to write the query after limit?