Re: Selecting first non-null values from a set of rows

Eli ha scritto: Hello, Say I get these rows in a regular query: col1col2col3 --- NULL B1 NULL NULLNULLNULL A3 B3 NULL A4 NULLC4 A5 B5 C5 NULLB6 C6 (It's important to keep the rows in that order). I want to get 1 row o

Re: Selecting first non-null values from a set of rows

Eli <[EMAIL PROTECTED]> wrote on 02/08/2005 03:27:42 PM: > > Eli <[EMAIL PROTECTED]> wrote on 02/08/2005 02:26:41 PM: > > > > > >>> Hello, > >>> > >>> Say I get these rows in a regular query: > >>> > >>> col1 col2col3 > >>> --- > >>> NULLB1NULL > >>> NULLN

Re: Selecting first non-null values from a set of rows

Eli <[EMAIL PROTECTED]> wrote on 02/08/2005 02:26:41 PM: Hello, Say I get these rows in a regular query: col1 col2col3 --- NULLB1NULL NULLNULLNULL A3 B3 NULL A4 NULLC4 A5 B5 C5 NULLB6 C6 (It's important to keep the row

Re: Selecting first non-null values from a set of rows

Eli <[EMAIL PROTECTED]> wrote on 02/08/2005 02:26:41 PM: > Hello, > > Say I get these rows in a regular query: > > col1 col2col3 > --- > NULLB1NULL > NULLNULLNULL > A3 B3 NULL > A4 NULLC4 > A5 B5 C5 > NULLB6 C6 > >

Selecting first non-null values from a set of rows

Hello, Say I get these rows in a regular query: col1col2col3 --- NULLB1 NULL NULLNULLNULL A3 B3 NULL A4 NULLC4 A5 B5 C5 NULLB6 C6 (It's important to keep the rows in that order). I want to get 1 row of the first non-