jackjohnson44

asked on

# sql group by calculated column

Hi, how can I group by a calculated column? I am trying to do what is below and it is not working.

select

case when StartingIv >= 0 and StartingIv < 0.1 then '0-0.1'

when StartingIv >= 0.1 and StartingIv < 0.2 then '0.1-0.2'

when StartingIv >= 0.2 and StartingIv < 0.3 then '0.2-0.3'

when StartingIv >= 0.3 and StartingIv < 0.4 then '0.3-0.4'

when StartingIv >= 0.4 and StartingIv < 0.5 then '0.4-0.5'

when StartingIv >= 0.5 and StartingIv < 0.6 then '0.5-0.6'

when StartingIv >= 0.6 and StartingIv < 0.7 then '0.6-0.7'

when StartingIv >= 0.7 and StartingIv < 0.8 then '0.7-0.8'

when StartingIv >= 0.8 and StartingIv < 0.9 then '0.8-0.9'

when StartingIv >= 0.9 and StartingIv < 1 then '0.9-1'

when StartingIv >= 1 and StartingIv < 1.1 then '1-1.1'

else 'ELSE'

end as IvRange

, Profit

from Trades

group by IvRange

select

case when StartingIv >= 0 and StartingIv < 0.1 then '0-0.1'

when StartingIv >= 0.1 and StartingIv < 0.2 then '0.1-0.2'

when StartingIv >= 0.2 and StartingIv < 0.3 then '0.2-0.3'

when StartingIv >= 0.3 and StartingIv < 0.4 then '0.3-0.4'

when StartingIv >= 0.4 and StartingIv < 0.5 then '0.4-0.5'

when StartingIv >= 0.5 and StartingIv < 0.6 then '0.5-0.6'

when StartingIv >= 0.6 and StartingIv < 0.7 then '0.6-0.7'

when StartingIv >= 0.7 and StartingIv < 0.8 then '0.7-0.8'

when StartingIv >= 0.8 and StartingIv < 0.9 then '0.8-0.9'

when StartingIv >= 0.9 and StartingIv < 1 then '0.9-1'

when StartingIv >= 1 and StartingIv < 1.1 then '1-1.1'

else 'ELSE'

end as IvRange

, Profit

from Trades

group by IvRange

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

good one: Qlemo :)