> >
> > When we get windowing functions, a lot of this pain will go away :)
> >
>
> Yes! Hope it won't be too long now. The patch seems to behave like it
> should
> now :)
> Hopefully we'll see it commited for 8.4.
>
> Though this does not look too much cleaner at least it's standard SQL:
>
> A preview for Madi:
>
> SELECT foo,bar
> FROM (SELECT foo,bar,
> ROW_NUMBER() OVER (PARTITION BY foo ORDER BY bar) AS pos
> FROM table
> ) AS t
> WHERE pos = 1
> ORDER BY bar;
>
> Probably easier to understand what's going on in this one.
>
> David.
>
Is Oracle's FIRST_VALUE function not a SQL standard? The way I would
do this in Oracle looks like:
SELECT foo, FIRST_VALUE(bar) OVER (PARTITION BY foo ORDER BY bar) as bar
FROM table
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/functions059.
htm