• Home
• com.alibaba
• druid
• 1.2.17
• source code
• query86.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

tpcds.query86.sql Maven / Gradle / Ivy

select sum(ws_net_paid)                         as total_sum
     , i_category
     , i_class
     , grouping(i_category) + grouping(i_class) as lochierarchy
     , rank()                                      over (
 	partition by grouping(i_category)+grouping(i_class),
 	case when grouping(i_class) = 0 then i_category end 
 	order by sum(ws_net_paid) desc) as rank_within_parent
from web_sales
   , date_dim d1
   , item
where d1.d_month_seq between 1200 and 1200 + 11
  and d1.d_date_sk = ws_sold_date_sk
  and i_item_sk = ws_item_sk
group by rollup (i_category, i_class)
order by lochierarchy desc,
         case when lochierarchy = 0 then i_category end,
         rank_within_parent limit 100