1795. Rearrange Products Table

내공얌냠 2022. 5. 30. 21:47

https://leetcode.com/problems/rearrange-products-table/

Rearrange Products Table - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com

select product_id, 'store1' as store, store1 as price
from Products
where store1 is not null
union
select product_id, 'store2' as store, store2 as price
from Products
where store2 is not null
union
select product_id, 'store3' as store, store3 as price
from Products
where store3 is not null

728x90