[MySQL] 基本メモ: データの集計 – 端くれプログラマの備忘録

件数

> select count(*) from users;

1	> select count(*) from users;

ユニークデータのみ(重複無し)の件数

> select ditinct team from users;

1	> select ditinct team from users;

最大値/最小値/平均値/合計

> select max(score) from users;
> select min(score) from users;
> select age(score) from users;
> select sum(score) from users;

> select max(score) from users;

> select min(score) from users;

> select age(score) from users;

> select sum(score) from users;

チームごとの平均スコア

> select team, ave(score) from users group by team;

1	> select team, ave(score) from users group by team;

乱数

> select rand(); 0以上1未満の乱数
> select * from users order by rand() limit 1;

1 2	> select rand(); 0以上1未満の乱数 > select * from users order by rand() limit 1;

関連記事