摘要:
monthsalesPerMonth122332445363写条SQL语句把上表转成下表:month总销量122537411514617答案:selects2.[month],Sum(s1.salesPerMonth)as'总销量' FromSaless1,Saless2 where s1.[month]<=s2.[month] Groupbys2.[month] 阅读全文
摘要:
Num124678101113写条SQL语句转成下表:Column1 Column21 24 46 810 1113 13selectMIN(Num),MAX(Num)from (selectROW_NUMBER()over (orderbyNum)rk,NumFromNumbers)AGroupby (A.rk-A.Num)orderbyMin(Num) 阅读全文