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;