微信公开课小程序热门讨论「一个SQL小程序」最新回复-用case语句!!mysql语句:selectorderdate,casewhensum(costperorder)170thenHighsaleselseLowsalesendas订单状态,sum(costperorder)fromordersGroupByorderdate;sqlserver语句略有不同:selectorderdate,订单状态=casewhensum(costperorder)170thenHighsaleselseLowsalesend,sum(costperorder)fromordersGroupByorderdate;你两条语句都试试!
selectorderdate,orderdate,sum(costperorder)astotalfromordersGroupByorderdaters(total)就是总价值 更多有关「一个SQL小程序」的疑问请扫码关注微信公开课+小程序!了解更多