1:
snum | sname | city | comm |
Peel | London | .12 | |
Serres | San Jose | .13 | |
Motika | London | .11 | |
Rifkin | Barcelona | .15 | |
Axelrod | New York | .10 |
2:
cnum | cname | city | rating | snum |
Hoffman | London | |||
Giovanni | Rome | |||
Liu | San Jose | |||
Grass | Berlin | |||
Clemens | London | |||
Cisneros | San Jose | |||
Pereira | Rome |
3:
onum | amt | odate | cnum | snum |
18.69 | 10/03/1990 | |||
767.19 | 10/03/1990 | |||
1900.10 | 10/03/1990 | |||
5160.45 | 10/03/1990 | |||
1098.16 | 10/03/1990 | |||
1713.23 | 10/04/1990 | |||
75.75 | 10/04/1990 | |||
4723.00 | 10/05/1990 | |||
1309.95 | 10/06/1990 | |||
9891.88 | 10/06/1990 |
........................................................................................... 1
................................................................... 1
?......................................... 1
.......................................... 2
................................................... 2
( )...................................... 2
............................................. 2
........................................................ 3
..................................................................... 5
SQL............................................................... 5
SQL: .......................................................................................................................................... 6
SQL?.......................................................... 6
ANSI?........................................................... 6
SQL............................................. 6
SQL............................................................. 7
...................................................... 7
SQL...................................................... 8
?.................................................... 8
..................................................... 8
..................................................................... 8
SQL............................................................... 9
|
|
SQL ....................................................... 10
.......................................................... 10
?......................................................... 10
?.................................................. 10
SELECT............................................................ 10
..................................... 11
SELECT........................................................... 11
.................................... 11
............................................... 12
................................................ 12
DISTINCT........................................................ 13
ALL DISTINCT....................................................... 13
..................... 14
.................................................................... 14
SQL.............................................................. 15
16
..................................................... 16
.......................................................... 17
.................................................................... 20
SQL.............................................................. 20
................................................................... 21
IN............................................................... 21
BETWEEN.......................................................... 22
LIKE............................................................. 23
(NULL) ....................................... 25
NULL............................................................. 25
NOT ............................. 25
.................................................................... 26
SQL.............................................................. 26
.................................................................. 27
?............................................. 27
?...................................... 27
COUNT................................................ 28
DISTINCT.................................................... 28
COUNT , .......................... 28
................................. 29
, .............................. 29
GROUP BY...................................................... 29
HAVING........................................................ 30
............................................ 32
.................................................................... 32
|
|
SQL.............................................................. 32
................................................................................................ 34
........................................................ 34
........................................ 34
.................................................................................................... 34
...................................................... 34
................................................. 35
............................................................... 36
.......................................................................... 37
........................................................... 37
NULL......................................................... 38
.................................................................... 38
SQL.............................................................. 38
, ...................................................................... 41
........................................................ 41
................................................... 41
...................................................... 41
........................... 42
43
............................................. 43
.................................................................... 44
SQL.............................................................. 44
........................................................................................................ 45
?................................... 45
................................................................ 45
................................................... 46
........................................................... 47
....................................................... 47
........................................ 47
.................................................................... 49
SQL.............................................................. 49
........................................................................................ 50
?................................................... 50
, ............................... 51
DISTINCT ................................................... 51
............................ 52
............................ 52
, IN 53
..................................... 55
..................................... 55
HAVING........................................... 55
.................................................................... 56
SQL.............................................................. 56
............................................................................................................. 57
|
|
................................... 57
....................................... 57
........................................................... 59
................................................. 59
HAVING.............................. 60
..................................... 61
.................................................................... 61
SQL.............................................................. 61
EXISTS.................................................................................................. 62
EXISTS?...................................................... 62
EXISTS........................................... 63
EXISTS ......................... 63
EXISTS ........................................ 63
NOT EXISTS.................................................. 64
EXISTS ......................................................... 64
........................................... 65
.................................................................... 66
SQL.............................................................. 66
ANY, ALL SOME............................................................................... 67
ANY SOME........................................ 67
IN EXISTS ANY............... 67
ANY ......................................... 69
ALL.................................................. 71
................................................... 72
ANY ALL............................................ 73
ANY, ALL, EXIST ... 73
....................................... 73
ANY ALL EXISTS (NULL)........................ 74
COUNT EXISTS......................................... 74
.................................................................... 75
SQL.............................................................. 75
UNION.............................................................................................. 77
.................................... 77
?....................... 77
UNION ............................................. 78
UNION................................... 79
UNION ORDER BY............................................ 80
....................................................... 81
.................................................................... 83
SQL.............................................................. 83
, ................................................................................ 85
DML............................................. 85
............................................................. 85
|
|
(NULL).......................................... 85
(INSERT)................................... 85
............................................... 86
................................................... 87
................................. 87
UPDATE ........................................ 87
................................... 87
(NULL) .................................... 87
.................................................................... 88
SQL.............................................................. 88
............................................................ 89
INSERT........................................ 89
............................................. 89
, ........... 90
DELETE........................................ 90
UPDATE........................................ 91
DML...................... 92
.................................................................... 92
SQL.............................................................. 92
............................................................................................................................. 93
.................................................. 93
................................................................... 94
...................................................... 94
......................................................... 95
, ........................ 95
........................................................... 95
.................................................................... 95
SQL.............................................................. 96
.......................................................................................... 97
........................................................ 97
.................................................... 97
(NULL) ......... 97
, ......................................... 98
...................................... 98
...................................... 98
.............................................. 99
.................................... 99
(CHECK).......................................... 100
CHECK, ... 100
, ....................... 101
.......................................... 101
................................................................... 102
SQL............................................................. 102
...................................................................................... 104
......................................... 104
............................................ 104
.................................... 104
FOREIGN KEY.................................................. 105
..................... 105
..................................... 105
.................................... 106
............................ 106
..... 106
............................... 106
............................................... 107
, ...................... 107
|
|
............................................... 107
..................................................... 108
,
.............................................. 109
................................................................... 110
SQL............................................................. 110
........................................................................................................... 111
?................................................. 111
CREATE VIEW...................................................... 111
............................................ 112
...................................................... 112
112
.................................................. 113
.............................................. 114
............................................... 115
....................................... 115
................................................... 115
................................................................... 115
SQL............................................................. 116
........................................................................ 117
............................................ 117
............................... 118
" "................................................ 118
............................... 118
, ............................ 119
............................................. 120
, ...... 120
................................................................... 121
SQL............................................................. 121
........................................................................................... 123
............................................................. 123
.............................................................. 123
................................................ 123
................................................... 123
GRANT............................................................ 124
, .................................. 124
........................... 124
ALL PUBLIC.................................... 125
WITH GRANT OPTION.................... 125
........................................................ 126
.................... 126
?....................................... 126
SELECT .................. 126
............................ 127
....................... 127
....... 127
................................................... 128
.............................................. 128
........................................ 128
................................................................... 129
SQL............................................................. 129
SQL............................................................................................................. 130
.................................................... 130
..................................... 130
..................................................... 130
....................................................... 131
?.......................... 131
?........................ 132
SQL ......................... 133
.......................................................... 134
......................................... 134
................................................................... 135
SQL............................................................. 135
SQL ................................................................. 136
.......................................................... 136
............................................... 136
.......................... 137
() ........... 137
........................................ 138
.................................................... 139
............................................ 142
................................................................... 143
SQL............................................................. 143
SQL ( SQL)........................................................... 144
SQL................................................... 144
SQL?.................................................... 144
SQL................................................ 144
SQL........................... 145
.................................................... 146
........................................... 146
................................................................... 147
SQLCODE.................................................................. 148
SQLCODE ............................. 148
WHENEVER..................................................... 149
................................................. 149
INDICATOR..................................................... 150
INDICATOR NULL SQL....... 151
INDICATOR................................ 152
................................................................... 152
SQL............................................................. 153
............................................................................................................... 154
1.................................................................. 154
2.................................................................. 154
3.................................................................. 154
4.................................................................. 154
5.................................................................. 155
6.................................................................. 155
7.................................................................. 156
8.................................................................. 156
9.................................................................. 156
10................................................................. 157
11................................................................. 157
12................................................................. 158
13................................................................. 158
14................................................................. 159
15................................................................. 159
16................................................................. 160
17................................................................. 160
18................................................................. 160
19................................................................. 161
20................................................................. 161
21................................................................. 162
22................................................................. 162
23................................................................. 162
24................................................................. 163
25................................................................. 164
SQL...................................................................................................................... 167
ANSI................................................................ 167
................................ 167
SQL........................................................................ 169
.............................................................. 169
FORMAT........................................................... 170
.................................................................. 171
INTERSECT MINUS........................................................ 171
....................................... 172
.................................................... 172
...................................................................................... 174
SQL ............................................................. 174
SQL .............................................................. 177
, SQL..................................................................................................... 182