Re: [SQL] challenging query

2001-10-06 Thread Masaru Sugawara
On Fri, 05 Oct 2001 17:03:41 METDST Haller Christoph wrote: > > > > Consider the following table: > > > > A B C D select? > > --- > > 1 FOO A1 100 n > > 1 BAR Z2 100 n > > 2 FOO A1 101 y > > 2 BAR

Re: [SQL] challenging query

2001-10-05 Thread Haller Christoph
> > Consider the following table: > > A B C D select? > --- > 1 FOO A1 100 n > 1 BAR Z2 100 n > 2 FOO A1 101 y > 2 BAR Z2 101 y > 3 FOO A1 102 y > 4 BAR

Re: [SQL] challenging query

2001-10-05 Thread Haller Christoph
> > Consider the following table: > > A B C D select? > --- > 1 FOO A1 100 n > 1 BAR Z2 100 n > 2 FOO A1 101 y > 2 BAR Z2 101 y > 3 FOO A1 102 y > 4 BAR

[SQL] challenging query

2001-10-04 Thread Chris Ruffin
Consider the following table: A B C D select? --- 1 FOO A1 100 n 1 BAR Z2 100 n 2 FOO A1 101 y 2 BAR Z2 101 y 3 FOO A1 102 y 4 BAR Z2 9