Re: SQL - Select lowest

[Michael Ryan <michaelrtr@xxxxxxxxx>]

Oh...this works...I think...

with temp as (select * from michael/myduptable) select field1,
min(field2) from temp group by field1

Does this make sense?


On Tue, Dec 8, 2009 at 9:32 AM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

> Things like this confuse me until someone shows me how simple it is. :)
> This is what I want to do:
>
> with temp as (select * from michael/myduptable) select * from temp having
> min(field2)
>
> Here's the data:
>
> FIELD1   FIELD2
>      1   ONE
>      2   TWOA
>      2   TWOB
>      3   THREE
>      4   FOURA
>      4   FOURB
>      4   FOURC
>
> I want this:
> 1 ONE
> 2 TWOA
> 3 THREE
> 4 FOURA
>
> I'm using a CTE table because the select that makes myduptable (in real
> life) is complex, and I thought this would make it easier. Best holiday
> wishes to anyone that can give me the answer. :)