selectsum(quarter1),sum(quarter2),sum(quarter3),sum(quarter4)

from

(selectquarter1,0quarter2,0quarter3,0quarter4

fromtablewhereminute

unionall

select0quarter1,quarter2,0quarter3,0quarter4

fromtablewhereminute>=15andminute

unionall

select0quarter1,0quarter2,quarter3,0quarter1

fromtablewhereminute>=30andminute

unionall

select0quarter1,0quarter2,0quarter3,quarter4

fromtablewhereminute>=45

)

//groupby^^^^^^^^^^^^

這樣查詢出來的內容，第一個欄位為，前十五分鐘內容，第二個欄位為中間十五分鐘內容…………