Re: [SQL] aggregation question

2010-12-01 Thread Samuel Gendler
On Tue, Nov 30, 2010 at 7:47 PM, Samuel Gendler wrote: > I have a fact table with a number of foreign keys to dimension data and > some measure columns. Let's assume I've got dimension columns a,b,c,d,e, > and f and measure columns x, and y. > > I need to be able to find the value of f, x, and y

[SQL] aggregation question

2010-11-30 Thread Samuel Gendler
I have a fact table with a number of foreign keys to dimension data and some measure columns. Let's assume I've got dimension columns a,b,c,d,e, and f and measure columns x, and y. I need to be able to find the value of f, x, and y for the row with min(x/y) when e in (1,2) and max(x/y) when e not