Re: MAX without FROM

[Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx>]

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;