摘要:
第一次看到这样的SQL语句,看不懂,其中用到了下面的不常用的聚集函数:GROUPING用于汇总数据用的运算符: ROLLUPSELECT CASEGROUPING(o.customerid)WHEN0THENo.customeridELSE'(Total)'END ASAllCustomersSummary, CASEGROUPING(od.orderid)WHEN0THENod.orderidELSE-1END ASIndividualCustomerSummary, SUM(od.quantity*od.unitprice)ASprice FROMOrderso,[Orde 阅读全文
摘要:
首先创建测试表、添加数据。createtable#t(aint,bint,cint,dint,eint) insertinto#tvalues(1,2,3,4,5) insertinto#tvalues(1,2,3,4,6) insertinto#tvalues(1,2,3,4,7) insertinto#tvalues(1,2,3,4,8) insertinto#tvalues(1,3,3,4,5) insertinto#tvalues(1,3,3,4,6) insertinto#tvalues(1,3,3,4,8) insertinto#tvalues(1,3,3,4,7) insert. 阅读全文