We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
I have never done a pivot table before this challenge and couldn't find any great tutorials or examples. Would you mind clarifying what its doing?
To me it looks like:
- You set an int variable for each column (which represents each row)
-I don't understand your select min statement
-The from sets up a temporary table?
-You then compare the select value to the case statement and add 1 to the respective column (to move the row value up)
-I don't understand the second case statements purpose.
Really cool stuff, trying to wrap my head around this.
Thanks for your time :)
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Occupations
You are viewing a single comment's thread. Return to all comments →
Hello,
I have never done a pivot table before this challenge and couldn't find any great tutorials or examples. Would you mind clarifying what its doing?
To me it looks like: - You set an int variable for each column (which represents each row) -I don't understand your select min statement -The from sets up a temporary table? -You then compare the select value to the case statement and add 1 to the respective column (to move the row value up) -I don't understand the second case statements purpose.
Really cool stuff, trying to wrap my head around this.
Thanks for your time :)