回答編集履歴
4
訂正
answer
CHANGED
|
@@ -1,1 +1,7 @@
|
|
|
1
|
-
|
|
1
|
+
・Oracle だけで
|
|
2
|
+
SELECT NAME
|
|
3
|
+
FROM TBL
|
|
4
|
+
ORDER BY ID
|
|
5
|
+
UNION ALL
|
|
6
|
+
SELECT '-'
|
|
7
|
+
FROM DUAL ;
|
3
勘違いのため取り消し
answer
CHANGED
|
@@ -1,9 +1,1 @@
|
|
|
1
|
-
・Access, SQL Server
|
|
2
|
-
SELECT ID, NAME + '-' AS NAME
|
|
3
|
-
FROM TBL
|
|
4
|
-
|
|
1
|
+
勘違いのため取り消し
|
|
5
|
-
|
|
6
|
-
・Oracle
|
|
7
|
-
SELECT ID, NAME || '-' AS NAME
|
|
8
|
-
FROM TBL
|
|
9
|
-
ORDER BY ID
|
2
訂正
answer
CHANGED
|
@@ -1,7 +1,9 @@
|
|
|
1
1
|
・Access, SQL Server
|
|
2
2
|
SELECT ID, NAME + '-' AS NAME
|
|
3
3
|
FROM TBL
|
|
4
|
+
ORDER BY ID
|
|
4
5
|
|
|
5
6
|
・Oracle
|
|
6
7
|
SELECT ID, NAME || '-' AS NAME
|
|
7
|
-
FROM TBL
|
|
8
|
+
FROM TBL
|
|
9
|
+
ORDER BY ID
|
1
訂正
answer
CHANGED
|
@@ -1,6 +1,4 @@
|
|
|
1
|
-
Accessはパス。
|
|
2
|
-
|
|
3
|
-
・SQL Server
|
|
1
|
+
・Access, SQL Server
|
|
4
2
|
SELECT ID, NAME + '-' AS NAME
|
|
5
3
|
FROM TBL
|
|
6
4
|
|