Re: Selecting All Columns Associated With Maximum Value of One Column

On Thu, 6 Oct 2011, David Johnston wrote:

> Missing the FROM before chemistry

D'oh! Obviously not yet sufficiently cafinated this morning.

>> Also, with the window function can I limit the output to a single str_name
>> and param?
>
> Not directly. After you create the windowed result you can turn it into a
> sub-query and filter that. The other form suggested (where quant = select
> max(quant) from chemistry where ...) is probably a better performer though
> for your need - I did't read the subject line closely enough and my two
> options don't directly give you what you are looking for. Though era ing
> the window query and then adding a (where quant_max = quant) clause would
> get you closer; quant_max being the column alias for the window
> expression.

Ah.

Thanks, David,

Rich