SQL code:
select datename(weekday,riqi) as 星期,
CUSTOMER_ID,
CUSTOMER_NAME,
CUSTOMER_ADDRESS,
BUY_TIME,
BUY_TIMES,
WRITE_TIMES,
sum(CARD_EN) as CARD_EN,
sum(BUY_MONEY) as BUY_MONEY,
sum(BC_YSJE) as BC_YSJE,
sum(SUM_USE) as SUM_USE,
sum(REMAIN_EN) as REMAIN_EN,
convert(varchar(10),BUY_TIME,120) as [date]
from
T_BUT_RECORD
group by
CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,convert(varchar(10),BUY_TIME,120)
union all
select '总计',
CUSTOMER_ID,
CUSTOMER_NAME,
CUSTOMER_ADDRESS,
BUY_TIME,BUY_TIMES
,WRITE_TIMES,
sum(BUY_MONEY) as BUY_MONEY,
sum(BC_YSJE) as BC_YSJE,
sum(SUM_USE) as SUM_USE,
sum(REMAIN_EN) as REMAIN_EN,
convert(varchar(10),getdate(),120)
from T_BUT_RECORD
group by CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES
datename,convert,getdate,求救啊~~
select format(riqi,'DDD') as 星期,
CUSTOMER_ID,
CUSTOMER_NAME,
CUSTOMER_ADDRESS,
BUY_TIME,
BUY_TIMES,
WRITE_TIMES,
sum(CARD_EN) as CARD_EN,
sum(BUY_MONEY) as BUY_MONEY,
sum(BC_YSJE) as BC_YSJE,
sum(SUM_USE) as SUM_USE,
可能因为工作的原因 接触数据库这块比较少，之前都是做程序这块，数据库这块都有专门的人来做 分工都很明细 所以对数据库这一块完全不了解。前段时间 去面试了几家公司 几乎都是在数据库这块挂掉的 连个简单的SQ ......
