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 같이 보기[ | ]

문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}