You are viewing a single comment's thread. Return to all comments →
my solution in oracle using window function
select id,age,coins_needed,power from ( select id,age,coins_needed,power, min(coins_needed) over (partition by w.code,age,power) as min_coins from wands w inner join wands_property wp on w.code = wp.code where wp.is_evil =0 ) where coins_needed = min_coins order by power desc,age desc;
Seems like cookies are disabled on this browser, please enable them to open this website
Ollivander's Inventory
You are viewing a single comment's thread. Return to all comments →
my solution in oracle using window function