質問編集履歴
1
SQL文のミスを修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -1,8 +1,8 @@
|
|
|
1
1
|
```
|
|
2
|
-
SELECT COUNT(*) AS COUNT_1 TABLE WHERE ID = 1;
|
|
2
|
+
SELECT COUNT(*) AS COUNT_1 FROM TABLE WHERE ID = 1;
|
|
3
3
|
```
|
|
4
4
|
```
|
|
5
|
-
SELECT COUNT(*) AS COUNT_2 TABLE WHERE ID = 2;
|
|
5
|
+
SELECT COUNT(*) AS COUNT_2 FROM TABLE WHERE ID = 2;
|
|
6
6
|
```
|
|
7
7
|
上記の条件を1つのSQL文にまとめ、下記のような結果を得たいのですが、
|
|
8
8
|
なかなか思いつきません。知見のある方ご教示いただけないでしょうか。
|