2014-12-19から1日間の記事一覧

SQLで色々計算する小技

なんとかごとの合計/集計/平均 SELECT nantoka,SUM(numbmer) FROM table GROUP BY nantoka ORDER BY nantoka; SELECT nantoka,COUNT(numbmer) FROM table GROUP BY nantoka ORDER BY nantoka; SELECT nantoka,AVG(numbmer) FROM table GROUP BY nantoka OR…