Shulou(Shulou.com)06/03 Report--

Monthly sales and total sales

A,01150

A,01200

B,01,1000

B,01800

C,01250

C,01220

B,01,6000

A,02,2000

A,02,3000

B,02,1000

B,02,1500

C,02350

C,02280

A,03350

A,03250

Create table t_store (

Name string comment 'Shop'

Months int comment 'month'

Money int comment 'amount'

)

Row format delimited fields terminated by ","

Load data local inpath "/ root/t_store.txt" into table t_store

Create view v_t_store

As

Select name,months,sum (money) money

From t_store

Group by name,months

Select name,months,money

, sum (money) over (partition by name order by months rows between unbounded preceding and current row) as t_money

From v_t_store

A 1 350 350

A 2 5000 5350

A 3 600 5950

B 1 7800 7800

B 2 2500 10300

C 1 470 470

C 2 630 1100

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.