Se poate face o interogare rollup sau cube partial, ca in Oracle?

"select continent As Continet, countryregioncode As Cod, name as Tara,sum(saleslastyear) As Vanzari
from SalesTerritory
group by name  rollup (continent,countryregioncode) "

Daca da, cum?