SQL COUNT()

1 개요

mysql> SELECT * FROM fruits;
+--------+
| value  |
+--------+
| Banana |
| Orange |
| Apple  |
| Orange |
| Orange |
+--------+
5 rows in set (0.00 sec)

mysql> SELECT COUNT(*) FROM fruits WHERE value='Orange';
+----------+
| COUNT(*) |
+----------+
|        3 |
+----------+
1 row in set (0.00 sec)

2 같이 보기

• 함수 array_count_value()