On Thu, 2006-01-12 at 12:58, Angshu Kar wrote:
> Hi,
> 
> Can I use Select max(a field returned from another query)?
> say, another query returns say 10,1,2,3,6,7 

Does this form help you:

select max(a) from (select 1 as a union select 2 union select 3) as b;

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to