回答編集履歴

4

訂正

2018/02/11 02:33

投稿

Orlofsky
Orlofsky

スコア16415

test CHANGED
@@ -1 +1,13 @@
1
- 勘違いのため取り消し
1
+ ・Oracle だけで
2
+
3
+ SELECT NAME
4
+
5
+ FROM TBL
6
+
7
+ ORDER BY ID
8
+
9
+ UNION ALL
10
+
11
+ SELECT '-'
12
+
13
+ FROM DUAL ;

3

勘違いのため取り消し

2018/02/11 02:33

投稿

Orlofsky
Orlofsky

スコア16415

test CHANGED
@@ -1,17 +1 @@
1
- ・Access, SQL Server
2
-
3
- SELECT ID, NAME + '-' AS NAME
4
-
5
- FROM TBL
6
-
7
- ORDER BY ID
1
+ 勘違いのため取り消し
8
-
9
-
10
-
11
- ・Oracle
12
-
13
- SELECT ID, NAME || '-' AS NAME
14
-
15
- FROM TBL
16
-
17
- ORDER BY ID

2

訂正

2018/02/11 02:26

投稿

Orlofsky
Orlofsky

スコア16415

test CHANGED
@@ -3,6 +3,8 @@
3
3
  SELECT ID, NAME + '-' AS NAME
4
4
 
5
5
  FROM TBL
6
+
7
+ ORDER BY ID
6
8
 
7
9
 
8
10
 
@@ -11,3 +13,5 @@
11
13
  SELECT ID, NAME || '-' AS NAME
12
14
 
13
15
  FROM TBL
16
+
17
+ ORDER BY ID

1

訂正

2018/02/11 02:16

投稿

Orlofsky
Orlofsky

スコア16415

test CHANGED
@@ -1,8 +1,4 @@
1
- Accessはパス。
2
-
3
-
4
-
5
- ・SQL Server
1
+ Access, SQL Server
6
2
 
7
3
  SELECT ID, NAME + '-' AS NAME
8
4