Online analytical processing (OLAP) Question: Download Questions PDF
In SQL the cross-tabs are created using:
a) Slice
b) Dice
c) Pivot
d) All of the mentioned
Answer:
a) Slice
Explanation:
pivot (sum(quantity) for color in ('dark','pastel','white')).
Explanation:
pivot (sum(quantity) for color in ('dark','pastel','white')).
Download OLAP Interview Questions And Answers
PDF