close

Google 關鍵字: group by many columns -> group by multiple columns sql

"Group By X" means "put all those with the same value for X in the one group.

"Group By X, Y" means "put all those with the same values for both X and Y in the one group."

GROUP BY 多個欄位: 指定到的欄位都要有相同的值 才能將TABLE的ROW結合在一起

Ref: http://stackoverflow.com/questions/2421388/using-group-by-on-multiple-columns

 

arrow
arrow
    全站熱搜

    Yuwan 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄