LIMIT clause question

[troy]

Hi,

I need to retrived a specific row from a query, these these specific
row number is the result of another query.

Is it possible to do that in one query with a subquery (mysql 4.1.x)?
Here is how I try (that gave me a syntax error.):

SELECT a FROM t1 WHERE a = 1 ORDER BY LIMIT (SELECT b FROM t2 WHERE c
= 2),1;

############
the 2 query standalone worked.

SELECT b FROM t2 WHERE c = 2; # return 3

So:
SELECT a FROM t1 WHERE a = 1 ORDER BY LIMIT 3,1; # return the good row
Any clue.
Thanks
Troy

[Bill Karwin]

troy wrote:

I need to retrived a specific row from a query, these these specific
row number is the result of another query.

Is it possible to do that in one query with a subquery (mysql 4.1.x)?

See http://dev.mysql.com/doc/mysql/en/SELECT.html:
"LIMIT takes one or two numeric arguments, which must be integer constants."

I take that to mean that the arguments _cannot_ be expressions of any
type. So I don't think you can use a subquery in place of those
arguments, or any expression involving a field name from the
select-list, etc.

I think you're stuck using one query to fetch the row number value, and
then use that return value when building up the SQL string for the
second query.

Regards,
Bill K.

[troy]

On Mon, 15 Nov 2004 14:56:42 -0800, Bill Karwin <bi**@karwin.com>
wrote:

troy wrote:

I need to retrived a specific row from a query, these these specific
row number is the result of another query.

Is it possible to do that in one query with a subquery (mysql 4.1.x)?

See http://dev.mysql.com/doc/mysql/en/SELECT.html:
"LIMIT takes one or two numeric arguments, which must be integer constants."

I take that to mean that the arguments _cannot_ be expressions of any
type. So I don't think you can use a subquery in place of those
arguments, or any expression involving a field name from the
select-list, etc.

I think you're stuck using one query to fetch the row number value, and
then use that return value when building up the SQL string for the
second query.

Regards,
Bill K.

I think you right, I will continue to use 2 distrincts queries.
Thanks
Troy