1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
| rbaraer@Ora10g> SELECT Column1||Column2 Column3, COUNT(*)
FROM
2 3 (
4 SELECT '1' Column1, '-1' Column2 FROM DUAL
5 UNION ALL
6 SELECT '1' Column1, '-2' Column2 FROM DUAL
7 UNION ALL
8 SELECT '1' Column1, '-2' Column2 FROM DUAL
9 UNION ALL
10 SELECT '2' Column1, '-1' Column2 FROM DUAL
11 )
12 GROUP BY Column3;
GROUP BY Column3
*
ERROR at line 12:
ORA-00904: "COLUMN3": invalid identifier
rbaraer@Ora10g> SELECT Column1||Column2 Column3, COUNT(*)
FROM
2 3 (
4 SELECT '1' Column1, '-1' Column2 FROM DUAL
5 UNION ALL
6 SELECT '1' Column1, '-2' Column2 FROM DUAL
7 UNION ALL
8 SELECT '1' Column1, '-2' Column2 FROM DUAL
9 UNION ALL
10 SELECT '2' Column1, '-1' Column2 FROM DUAL
11 )
12 GROUP BY Column1||Column2;
COL COUNT(*)
--- ----------
1-1 1
1-2 2
2-1 1
rbaraer@Ora10g> SELECT Column3, COUNT(*)
FROM
2 3 (
4 SELECT Column1||Column2 Column3
5 FROM
6 (
7 SELECT '1' Column1, '-1' Column2 FROM DUAL
8 UNION ALL
9 SELECT '1' Column1, '-2' Column2 FROM DUAL
10 UNION ALL
11 SELECT '1' Column1, '-2' Column2 FROM DUAL
12 UNION ALL
13 SELECT '2' Column1, '-1' Column2 FROM DUAL
14 )
15 )
16 GROUP BY Column3;
COL COUNT(*)
--- ----------
1-1 1
1-2 2
2-1 1
rbaraer@Ora10g> |
Partager