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
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