IBM
®
DB2
®
(C}]b
SQL kE
f>
7
SB84-0223-00
IBM
®
DB2
®
(C}]b
SQL kE
f>
7
SB84-0223-00
Z9C>JOM|'VDz7.0,kNDZ1093D:=<C. "bBn;PD;cE"#
>D5|, IBM D({E"#|ZmI-iBa),"\f((#$#>vfo|,DE";|(NNz7#$,R>V
aa)DNNyw;&wgKbM#
(}z1XD IBM zmr IBM V?I):vfo,r_,(}Bg 1-800-879-2755(Z@z)r 1-800-IBM-4YOU(Z
SCs)4):vfo#
1z"ME"x IBM s,4Zh IBM G(P(, IBM TZzya)DNNE",P({TNN|O*J1D==9C
r"",x;XTz:NNpN#
© Copyright International Business Machines Corporation 1993, 2000. All rights reserved.
?<
6-9C .............v
>iD`XD5 ...........v
;vT><( ............v
Z1B X5}]bM SQL........1
Z2B i/}] ...........3
m ................3
S< ...............3
#= ...............4
}]`M .............4
Z3B 4(mMS< .........9
4(m ..............9
ek}] .............10
|D}] .............12
>}}] .............12
4(S< .............13
9CS<4&m}] ........14
Z4B 9C SQL odf!}] .....17
,S}]b ............18
wims .............18
!qP ..............19
!qP ..............20
+PxPEr............22
}%X4P ............23
KcNr .............24
9Cmo=4Fc5 .........24
xmo=|{............25
S`vmP!q}] .........25
9CSi/ ............26
9C/} .............27
P/} .............27
j?/} ............28
m/} .............29
Vi...............29
+ WHERE Sdk GROUP BY Sd;p
9C..............30
Z GROUP BY Sd.s9C HAVING S
d ..............30
Z5B mo=MSi/ ........33
j?+i/ ............33
*;}]`M............33
u~mo= ............34
mmo= .............35
6Wmmo=...........35
+2mmo=...........36
`X{ ..............37
`XSi/ ............38
5V`XSi/ ..........40
Z6B Zi/P9CKc{M=J .....45
C/OKc{iOi/.........45
UNION Kc{ ..........45
EXCEPT Kc{..........46
INTERSECT Kc{ ........47
=J...............47
9C IN =J ..........48
9C BETWEEN =J ........48
9C LIKE =J..........49
9C EXISTS =J .........49
(?=J ............50
Z7B _6 SQL..........51
C<xM%"w5)L5fr ......51
X|V .............51
(;<x ............52
N<j{T<x ..........52
mli<x ...........53
%"w .............54
,S...............57
4Si/ .............61
ROLLUP M CUBE i/ .......61
]ii/ ............62
OLAP /} ............62
Z8B (FMv?}]Yw .......65
C'(e`M............65
C'(e/}............66
sTs (LOB) ...........67
YwsTs (LOB) .........67
© Copyright IBM Corp. 1993, 2000 iii
