You are reading a single comment by @cyberyark and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@cyberyark
There is a pivot function in oracle from 11 onwards i think.
http://www.oracle.com/technetwork/articles/sql/11g-pivot-097235.html
It will basically mimic the picot table you are creating in excel but i'm wondering if there is some other left join shenanigans you can do to calculate this stuff.