Thanks Scott. I've used another way of getting the max - I've used order by desc in my inner query and selected top 1 to get the max value ...On 1/12/06,
Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Thu, 2006-01-12 at 13:14, Angshu Kar wrote:> What are 1 ,2 and 3 in your query?>> Here is my inner q
On Thu, 2006-01-12 at 13:14, Angshu Kar wrote:
> What are 1 ,2 and 3 in your query?
>
> Here is my inner query which returns a set of min values. I want to
> get the max out of the returned mean values...
>
> select min(evalue) as M from distance where query_id
> in (select entry_id from partiti
What are 1 ,2 and 3 in your query?Here is my inner query which returns a set of min values. I want to get the max out of the returned mean values...select min(evalue) as M from distance where query_id
in (select entry_id from partition where partition = 849) On 1/12/06, Scott Marlowe
<[EMAIL PROT
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 b
Hi,Can I use Select max(a field returned from another query)?say, another query returns say 10,1,2,3,6,7
Thanks,AK-- Ignore the impossible but honor it ...The only enviable second position is success, since failure always comes first...
