I have a table like this
Product type sold
beer hotel 20
beer hotel 30
beer inn 20
beer inn 40
coke b&b 20
coke hotel 40
coke hotel 10
and want to get the result like
product hotel inn b&b
beer 50 60 0
coke 50 0 20
How to write a query (Oracle)
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.