关闭

关闭

关闭

封号提示

内容

首页 IBM DB2通用数据库SQL入门.pdf

IBM DB2通用数据库SQL入门.pdf

IBM DB2通用数据库SQL入门.pdf

上传者: 138*****326@sina.cn 2011-10-10 评分 0 0 0 0 0 0 暂无简介 简介 举报

简介:本文档为《IBM DB2通用数据库SQL入门pdf》,可适用于IT/计算机领域,主题内容包含IBMDB(C}bSQLkEf>SBIBMDB(C}bSQLkEf>SBZC>JOM|'VDz,kNDZD:=<C"bBnPDcE"#>D|,IBM符等。

IBMDB(C}bSQLkEf>SBIBMDB(C}bSQLkEf>SBZC>JOM|'VDz,kNDZD:=<C"bBnPDcE"#>D|,IBMD({E"#|ZmIiBa),"f((#$#>vfo|,DE"|(NNz#$,R>Vaa)DNNywwgKbM#(}zXDIBMzmrIBMVI):vfo,r,(}Bg(Zz)rIBMYOU(ZSCs)):vfo#z"ME"xIBMs,ZhIBMG(P(,IBMTZzya)DNNE",P({TNN|O*JD==Cr"",xXTz:NNpN#CopyrightInternationalBusinessMachinesCorporation,Allrightsreserved<Cv>iD`XDvvT><(vZBX}bMSQLZBi}mS<#=}`MZB(mMS<(mek}|D}>}}(S<CS<m}ZBCSQLodf!},S}bwims!qP!qPPxPEr}XPKcNrCmo=Fcxmo=|{S`vmP!q}CSiC}P}j}m}ViWHERESdkGROUPBYSdpCZGROUPBYSdsCHAVINGSdZBmo=MSiji*}`Mu~mo=mmo=Wmmo=mmo=`X{`XSiV`XSiZBZiPCKc{M=JCOKc{iOiUNIONKc{EXCEPTKc{INTERSECTKc{=JCIN=JCBETWEEN=JCLIKE=JCEXISTS=J(=JZBSQLC<xM"w)LfrX|V(<xN<j{T<xmli<x"w,SSiROLLUPMCUBEiiiOLAP}ZB(FMv}YwC'(e`MC'(e}sTs(LOB)YwsTs(LOB)CopyrightIBMCorp,iii(CDfw<S<DiS<P!qP=<Ay>}bmy>}b(y>}b*A}y>}bCLSCHEDmDEPARTMENTmEMPLOYEEmEMPACTmEMPPHOTOmEMPRESUMEmINTRAYmORGmPROJECTmSALESmSTAFFmSTAFFGm}`M*BLOBMCLOBDy>D~QuintanaD`,QuintanaDrzNichollsD`,NichollsDrzAdamsonD`,AdamsonDrzWalkerD`,WalkerDrz=<BCDBJObDBPDFD~Mr!DiDBE"r!PDFi):r!iDB*zDCJ*zozi*zE"CDBr<hCD~qwQw*zE"=<C"bBn"aLjw}kIBM*zE"ivSQLkEC>iG*aioT(SQL)MX}bDuC'`D#>i:vVZDBzPCDSQLDy>En#vwgNP}bYwNq#v(}r>}>Nq#g{zGm,Z"T>iPDNN>},zC:vUlYkEiPEvDGy*zDYwMdC~qw#CZ=h!n(SAMPLE}b#IS|nPa>(SAMPLE}b#N{SQLReferenceTq!ji#"b,*T:D}EkDBSAMPLE}b#v(}qlYkEiPD<(DBmC'ID#g{z"Gm,r*#zPP'DC'IDJD(^MX(EIf!SAMPLE}b#>iD`XDzIa"VBPvfoTzPC:lYkE|,MC}bmLryh*DE"#SQLReference|,SQLN<E"#mO|,hF"Vk,$*Z>XrM'z~qwPf!D}byhDE"#ApplicationDevelopmentGuideVCLr*"}LTgN`k"`kMPTBbyDCLr:Ck=SQLf!}bDCLr,rw*DBf"}L(CSQLProcedureoTrd|'VDLrhFoT)KPDCLr#vT><(>iCBP<(#ZeZ>}P,|m>$(eD|nMX|V#eVm>BfdPViv:viBuov}CmvE"#CopyrightIBMCorp,vsVem>BfdPViv:vI$(eD|nMX|V#vX(}rP{D>}#viSQLkEZBX}bMSQLX}bP,}f"ZmP#mGPMPDO#N{ZD<IqCmD<N>}#P()MP(=)QZ<Ojv#aioT(SQL)GCZ(}(P"mT|GdDwVXlwr|B}D#SQLGZX}bP(eMm}Dj<oT#SQLodI}bmLrP#}bmLrGm}DFczLr#VxX}bGZ`vVx(F*Zc)Om}DX}b#mbVxDvr=(GvVxS*(omFcz#Z>iP,RGQXcPZVx}bO#ITCvgf(g|nPmw(CLP)r|nPD(CC)),(}=SQLf!y>}b""TKP>iPDyP>}#CopyrightIBMCorp,SQLkEZBi}>BxvKm"S<T#=DX*Enw#CwGvcEv,T>KX}bD,~idD,S#nsZr*VK)X*DMO#CD}`M#mmGI(DP}MIdDP}iIDa#PGi}`M`,D#PGiImPvG<D,xD#ZmPXTPxPEr#*Ta{xPEr,XkZSmP!q}DSQLodPT=(Er#ZvPMPD`GvF*DX(}n#}g,Z<P,’Sanders’GmPDv#ymfEC'},R|GCCREATETABLEod(D#a{mGiP,}bmLrSvr`vym!qrzIbiPTzci*s#<wKmDV#PMPQjG#S<S<a)KZvr`vmPi}Dfz=(#|GmODv,Z#<mD<CopyrightIBMCorp,S<Jm`vC'i,}D,m>#}g,vC'IT,f!vXZMD}m#mI=XZ{Dr}DMD},=d|EDMD}#P<KI=yPMDNUZ={GD$Jiv,xFaKI=$Jiv=NUZ#vbyDC'CvSmIzDS<xPYw#vS<<T>*vm"PT:D{F#CS<DEcGzITC|GXFTtP}Df!#yT,,DKITf!}D,PrP##=#=GQ|{DTs(gmMS<)DO##=a)K}bPTsDV`#(m"S<rNNd||{Ts,~=(K#=#r,ITCCREATESCHEMAodT=(|#Z(|{Ts,ICX(#=D{F^((X*)CTsD{F#|{TsD{FP=vV,dP,{FDvVGTd(TsD#={#g{(#={,rTTs(!#=#(!#=D{FGPodDC'D(^ID#)TZ=SQL(VCP>iPD>}D=(),(^ID*CCONNECTod(DC'ID#}g,g{m{*STAFF,y(DC'ID*USERXYZ,r^(Dm{*USERXYZSTAFF#N{ZD:,S}bTq!XZCONNECTodDji#)#={G#tD#}g,$DC'(e}tZSYSFUN#=,Z}ZSYSIBM#=#N<SQLReferenceTq!XZCREATESCHEMAodDji#}`M}`M(e#}"P"^wd"}"mo=T(CDfwISD#>Zhv>}P}CD}`M#PXd{}`MDj{PmMw,N<SQLReference#V{V{GvVZrP#V{D$H*CrPPDVZ}#g{$H*c,rCV{DF*UV{#($V{SQLkECHAR(x)G($V{#$HtTxXkZMdR|(=#d$V{d$V{P}V`M:VARCHAR"LONGVARCHARTCLOB#VARCHAR(x)`MGd$V{,rK,IT$H*DV{ekVARCHAR()P,xCV{D$HT*#N{ZD:sTs(LOB)Tq!XZCLOBDji#<NV{<NV{GvVZV{}rP#($<NV{GRAPHIC(x)G($V{#$HtTxXkZMd,"|(M#d$<NV{d$<NV{P}V`M:VARGRAPHIC"LONGVARGRAPHICTDBCLOB#N{ZD:sTs(LOB)Tq!XZDBCLOBDji#~xFV{~xFV{GvVZrP#|CZ#fG},g<sH#~xFsTs(BLOB)G~xFV{#N{ZD:sTs(LOB)TKbji#}VyP}V<P{EMH#HG}{ETbD}r}V}#SMALLINTSMALLINT(!M{})GH*D=VZ{}#INTEGERINTEGER(sM{})GH*DDVZ{}#BIGINTvBIGINT(s{})GvH*DVZ{}#REALREAL(H!c})G}D|F#DOUBLEDOUBLE(H!c})G}D|F#DOUBLEFFLOAT#ZBi}DECIMAL(p,s)DECIMALGvxF}#!}cDCI}VDH(p)M!}(s)(#HG}VD},Xk!Z#!}G!}V}VD}RG!ZrHZH#g{(HM!},rxFD!H*,!!}*#UZdUZdGUZ"dTdAG(vq=*yyyyxxddhhmmssDm>P'UZMdDV{)Dm>(#UZdITCZ)cuKcMV{Kc"Rk)V{G`D,G|GHGV{G}V#UZUZV*}vV(j"BTU)#ddGC!F=(lZDdD,V*}vV(!"VSTk)#dAGdAGG(UZMdD,V*vV(j"B"U"!"VS"kT"k)#UUGvxpZyPGUDXb#|bEPPDGP^NNd{#yP}`M<fZU#BmvT>>}PyCD}`MDXT#yP}V}`M<(eZ('Z#C}V}`M'|(ZKmP#ITCKmw*}}`MC(DlYN<#}`M`MXT>}r'CHAR()($V{ns$H*’Sunnyday’VARCHAR()d$V{ns$H*’Sunnyday’SMALLINT}V$H*vVZH*'*AINTEGER}V$H*vVZH*'*ABIGINT}V$H*vVZH*'*A>iPRGXCUZdDISOm>#SQLkE}`M`MXT>}r'REAL}VH!c|F'GEAE,rEAE,r*DOUBLE}VH!c|F'GEAErEAE,r*DECIMAL(,)}VHG!}G'G**A**DATEUZdI}ViIDTIMEUZdI}ViIDTIMESTAMPUZdIViIDN{SQLReferencePD}`MfTmTq!ji#ZBi}SQLkEZB(mMS<>BhvKgNEZDB(C}bP(MYwmMS<#AI(}<mM>}PmMS<DX#>B|(:v(mM(S<vek}v|D}v>}}vCS<m}(mCCREATETABLEod(T:Dm,(P{M`MT<x#<xZZD:C<xM"w)LfrPxPV#BPod(v{F*PERSDm,CmkSTAFFm`F,Pv=SPBIRTHDATE#CREATETABLEPERS(IDSMALLINTNOT,NAMEVARCHAR(),DEPTSMALLINTWITHDEFAULT,JOBCHAR(),YEARSSMALLINT,SALARYDECIMAL(,),COMMDECIMAL(,),BIRTHDATEDATE)Kod(v|,}Dm#BZhvgN}ekBm#g>}Py>,TP<(K{FM}`M#}`MZZD:}`MPxPV#NOTGI!D,IT(|Tm>PPJmPU#!GI!D#ITZCREATETABLEodP(m`d{!n,g(<xrN<<x#PXyP!nDji,N{SQLReferencePDCREATETABLEod#CopyrightIBMCorp,ek}(Bm,Bm|,NN}#*BDPdkmP,CINSERTod#KodP=V(Cq=:v(}ZVq=,zICVALUESSd(Pr`PDP#TB}v>}yCK(Cq=}ekmP#v(}mVq=,zI(ixG(VALUES,jd{mMrS<PDPDP#iGINSERTrCREATEVIEWodPyCD!qod"rGzZ=JsfD!qod#(Z(EPDi(#F*Si#y(mQ!qD!!n,TZvekDP,*Pa)vrSv!#wV}`MD!ZSQLReferencePxPV#BPodCVALUESSdP}ekPERSmP:INSERTINTOPERSVALUES(,'Harris',,'Sales',,,,'')TBodCVALUESSd}PekPERSmP,KmPvID"U{T$wGQ*D#g{P(e*NOTRP!,rXk*CP(v#CREATETABLEodPDP(eODNOTSdITCJWITHDEFAULT)d#g{P(e*NOTWITHDEFAULTr#}!(gWITHDEFAULT),"RzZPPmP(CP,r!ekAQekPDCPP#}g,ZCREATETABLEodP,v*DEPTP(K!"C(e*#rK,EE(DEPT)hC*,xNNd{T=x(DP<hC*U#INSERTINTOPERS(NAME,JOB,ID)VALUES('Swagerman','Prgmr',),('Limoges','Prgmr',),('Li','Prgmr',)BPodXekDa{:SELECT*FROMPERSIDNAMEDEPTJOBYEARSSALARYCOMMBIRTHDATEHarrisSalesSQLkESwagermanPrgmrLimogesPrgmrLiPrgmr"b,ZKivB,"xvP(#UT>*FE(–)#*K,P{PmDNrM}`M<XkkVALUESSdPa)DT#g{!TP{Pm(gZv>}PGy),rVALUESsD}PmDNrXkk|GyekADmPDPNr`,,D}XkHZmPPD}#vXkk|yekADPD}`M`#g{P(e*IU,R(CPD,rUxekPPDCP#r*xPPDG)P(,yTBP>}UekYEARS"COMMMBIRTHDATEP#INSERTINTOPERS(ID,NAME,JOB,DEPT,SALARY)VALUES(,'Perna','Sales',,)INSERTodDZ~Vq=TZCmmPDPDndmG#=c#gOyv,(ixG(VALUES,Tjd{mMrS<PDPPDP#BP>}SSTAFFmP!qEDID},"|ekPERSmP:INSERTINTOPERS(ID,NAME,DEPT,JOB,YEARS,SALARY)SELECTID,NAME,DEPT,JOB,YEARS,SALARYFROMSTAFFWHEREDEPT=ZKeks,BPSELECTodkINSERTodPizzDa{`,#SELECTID,NAME,DEPT,JOB,YEARS,SALARYFROMPERSWHEREDEPT=a{*:IDNAMEDEPTJOBYEARSSALARYMarenghiMgrO'BrienSalesQuigleySalesNaughtonClerkAbrahamsClerkZB(mMS<|D}CUPDATEod|DmPD}#CKod,IT|DzcWHERESdQwu~DPPDPr`PD#BP>}|BID*DMDE":UPDATEPERSSETJOB='Prgmr',SALARY=SALARYWHEREID=SETSd(*|BDP"a)#WHERESdGI!D,|(*|BDP#g{!TWHERESd,r}bmLrCza)D|BmrS<PDP#ZK>}P,WH|{m(PERS),s(*|BPDu~#$EkDE"Q|D:CMD$w|D*Prgmr,$JvSK$#IT(}|(CZ=Pr|`PDWHERESd|D`P}#BP>}xvzD$JvS:UPDATEPERSSETSALARY=SALARY*WHEREJOB='Sales'>}}CDELETEod,yZWHERESdP(DQwu~SmP>}}P#BP>}>}dPMID*DP:DELETEFROMPERSWHEREID=WHERESdGI!D,|(*>}DP#g{!TWHERESd,r}bmLr>}mrS<PDyPP#ITCDELETEod>}`P#BP>}>}dPME(DEPT)*DyPP:DELETEFROMPERSWHEREDEPT=>}P,G}{vP,xG}CPPDX(P#SQLkE*>}mD(edZ,I"vDROPTABLEod,gSQLReferencePyv#(S<gZZD:S<PyVDGy,S<a)Zvr`vmPi}Dfz=(#(}(S<,ITTkCwVC'iDE"xP^F#BP<mT>S<MmdDX#Z<P,ViewA^F*If!TABLEADPACMAC#ViewABJmf!TABLEAPDPACMTABLEBPDPBC#(}(ViewA,C'ITPDf!(^F*TABLEA,x(}(VIEWAB,rGf!(^F*=vmPD)P#<mMS<dDXZB(mMS<BPod(STAFFmPEZDGmKDS<,dP$JMp(}ymT>#CREATEVIEWSTAFFONLYASSELECTID,NAME,DEPT,JOB,YEARSFROMSTAFFWHEREJOB<>'Mgr'ANDDEPT=Z(S<s,BPodT>S<DZ:SELECT*FROMSTAFFONLYKodzzBPa{:IDNAMEDEPTJOBYEARSPernalSalesJamesClerkSneiderClerkw*v|nkD>},RGICSTAFFMORGm(vPvvE{FMEmU{DS<#TBod(KS<:CREATEVIEWDEPARTMENTMGRSASSELECTNAME,DEPTNAMEFROMSTAFF,ORGWHEREMANAGER=ID(S<,ITCWITHCHECKOPTIONSd,=S<xmS=(}S<TmxPDekM|B#KSd<B}bmLri$TS<DNN|BrekGq{OCS<D(e,"xG){O(eD|Brek#g{!TKSd,rliS<(eDekM|B#PXWITHCHECKOPTIONgNpwCDji,N<SQLReferencePDCREATEVIEWod#CS<m}sSELECTody,INSERT"DELETETUPDATEodCZS<,MCsS<GvmGy#b)odmy>ymPD}#rKYNf!CS<,CnBDymT|xPFc#g{CWITHCHECKOPTIONSd,rCS<^DD}IZS<DXf!PvV,rGC}IY{ODS<(e#TB>}|BCZS<FIXEDINCOME:SQLkECREATEVIEWFIXEDINCOME(LNAME,DEPART,JOBTITLE,NEWSALARY)ASSELECTNAME,DEPT,JOB,SALARYFROMPERSWHEREJOB<>'Sales'WITHCHECKOPTIONUPDATEFIXEDINCOMESETNEWSALARY=SALARY*WHERELNAME='Li'}K#i!nTb,HS<PD|BH'ZTymPERSD|B:UPDATEPERSSETSALARY=SALARY*WHERENAME='Li'ANDJOB<>'Sales'"b,IZS<GZCREATEVIEWFIXEDINCOMEPT<xJOB<>'Sales'CWITHCHECKOPTION(D,yTLimogeswvzJmBP|B:UPDATEFIXEDINCOMESETJOBTITLE='Sales'WHERELNAME='Limoges'|BImo=SALARYCOMMrSALARY*(eDP#g{(ev|,vr`vbyDPDS<,rPPTb)PDUPDATEX(#Z|,byDPDS<OJmINSERTod,JmDELETEod#VZRGVvPNNP(e*NOTDmPERS#IT(}FIXEDINCOMES<PekmPERSP,CS<|,y>mPERSDID"YEARS"COMMrBIRTHDATE#{vS<P=DPJXhC*Ur!#GmPERSQPID(e*NOT#g{"T(}FIXEDINCOMES<ekP,rT<UekZ{vS<P=DyPPERSP#IZIDP|(ZS<P"RCPJmU,yTJm(}CS<xPek#PX^DS<DfrM^F,N<SQLReferencePDCREATEVIEWod#ZB(mMS<SQLkEZBCSQLodf!}>ZvgNCSQLod,S}bMlw}#Z>}P,RGxvK*dkDod,(s`}ivB)sfzEZTy>}b"vCodT>Da{#"b,dRGCsVT>od,ITCs!VlOdkb)od(C}E(’)r}E(’’)(pDod}b)#DB(C}b|(DSAMPLE}bIvmiI,gZD:=<Ay>}bmPyP#ICZ=hte(K}b#IS|nP(SAMPLE}b#N{SQLReferenceTKbji#"b,DB(C}b|,d|y>}b,|G>}VbPDMOLAPStarter$d#KiPD>}vCcSAMPLE}b#S}bhC==D,,zIXk(}xyCDm{SO#={Mvdcw*:^(b)m{#TZ>iPD>},Y(!#=*USERID#yTITmORG}C*USERIDORG#IJmbyvGqPX*#>B|(:v,S}bvwimsv!qPM!qPvPxPErM}XPvKcNrvCmo=Fcvxmo=|{vS`vmP!q}vCSivC}vViCopyrightIBMCorp,,S}bzXkHk}b,S,ECSQLodirYwC}b#CONNECTod}b,SkC'{`X*#}g,*,SSAMPLE}b,ZDB|nPmwPdkBP|n:CONNECTTOSAMPLEUSERUSERIDUSINGPASSWORD(#!qDGZ~qwOP'DC'IDMZn)#ZK>}P,USERD*USERID,USINGD*PASSWORD#BPE"fz,SI:}b,SE"}bz=DBNTSQL(^ID=USERID>X}bp{=SAMPLE),SO,MIT*<Yw}b#PX,SDji,N<SQLReferencePDCONNECTod#wimsZNN>}PvVdkms,rZPSQLodZdvm,}bmLraXmsE"#msE"IE"j{"r*wTSQLSTATEiI#SQLSTATEmsGDBPzDmsk#SQLSTATEms{OISOANSISQLj<#}g,g{ZCONNECTodPC'IDrZn},r}bmLrXE"j{SQLNTSQLSTATE#CE"gB:SQLNa)DC'{MrZn}#SQLSTATE=IT(}dkvJE(),sdkE"j{rSQLSTATEq!XZmsE"Dji:SQLNrSQLrSQLkE"b,msSQLNDwP}Z~PmwSQLCODE*#SQLCODE*zX(Dmsk#TN((*)rC(OX)aDE"j{m>vms,"RP:SQLCODE#TW(f)aDE"j{m>vf,"RP}SQLCODE#!qPCSELECTodSmP!qX(DP#ZCodP(C:EVtDP{Pm#KPmF*!qPm#BPodSSAMPLE}bDORGmP!qE{F(DEPTNAME)MEE(DEPTNUMB):SELECTDEPTNAME,DEPTNUMBFROMORGTOodzzBPa{:DEPTNAMEDEPTNUMBHeadOfficeNewEnglandMidAtlanticSouthAtlanticGreatLakesPlainsPacificMountain(}CGE(*)ISmP!qyPP#Bv>}PvKORGmPDyPDPMP:SELECT*FROMORGKodzzBPa{:DEPTNUMBDEPTNAMEMANAGERDIVISIONLOCATIONHeadOfficeCorporateNewYorkNewEnglandEasternBostonMidAtlanticEasternWashingtonSouthAtlanticEasternAtlantaGreatLakesMidwestChicagoPlainsMidwestDallasPacificWesternSanFranciscoMountainWesternDenverZBCSQLodf!}!qP*SmP!qX(P,ZSELECTodsCWHERESd(*!qDPXkzcDu~#SmP!qPDj<GQwu~#Qwu~Ivr`v=JiI#=J(XZPGfrGY(r*)Du~#ICBPy>=JZWHERESdP(u~:=Jx=yxHZyx<>yxHZyx<yx!Zyx>yxsZyx<=yx!ZrHZyx>=yxsZrHZyISISNOTbTUZlQwu~,*"bT}V}`MPcuKc,"Z`}`MdxPHO#}g,D>V{k}VxPHO#g{}ZyV{!qP,rCXkC}E(p(}g,WHEREJOB='Clerk'),"RdkDvV{Xkk}bPDjy#g{}Z}bPG!D,xzCsN=dk|,!qP#g{}Zy}V!qP,CC}E(p(}g,WHEREDEPT=)#BP>}SSTAFFmP!qEDP:SELECTDEPT,NAME,JOBFROMSTAFFWHEREDEPT=KodzzBPa{:DEPTNAMEJOBSandersMgrPernalSalesJamesClerkSneiderClerkBv>}CAND(`vu~#IT(Nb`vu~#C>}SSTAFFmP!qEPD:SQLkESELECTDEPT,NAME,JOBFROMSTAFFWHEREJOB='Clerk'ANDDEPT=KodzzBPa{:DEPTNAMEJOBJamesClerkSneiderClerkZdPdkR'V!DPPvVU#XphC*UDX=ITvVU#UZ(e*'VUDPPvV#ZD:(mPVKZmP(eM'VU#C=JISMISNOTliU#BPodPvKp*DM:SELECTID,NAMEFROMSTAFFWHERECOMMISKodzzBPa{:IDNAMESandersMarenghiHanesPlotzFrayeMolinareLuDanielsJonesLeaQuillckU`,#BPod!qmPp*cDvK:SELECTID,NAMEFROMSTAFFWHERECOMM=r*y>mPDCOMMPPPc,yTXDa{*U#Bv>}!qSTAFFmPYEARSDsZDyPP:ZBCSQLodf!}SELECTNAME,SALARY,YEARSFROMSTAFFWHEREYEARS>KodzzBPa{:NAMESALARYYEARSHanesLuJonesQuillGrahamPxPErzIk*E"X(NrX#CORDERBYSdE"vr`vPPDxPEr#BPodT>EPMCj}ErDM:SELECTNAME,JOB,YEARSFROMSTAFFWHEREDEPT=ORDERBYYEARSKodzzBPa{:NAMEJOBYEARSDavisSalesGafneyClerkEdwardsSalesQuillMgr(ORDERBYw*{vSELECTodPDnsvSd#ZKSdP|{DPITGmo=rmDNNP#ORDERBYSdPDP{XZ!qPmP(#I(}ZORDERBYSdPT=(ASCrDESCP}rrrxPEr#g{H(ASC,(DESC,rT}rPxPEr#BPodMCj}TrT>EPDM:SELECTNAME,JOB,YEARSFROMSTAFFWHEREDEPT=ORDERBYYEARSDESCKodzzBPa{:SQLkENAMEJOBYEARSQuillMgrEdwardsSalesDavisSalesGafneyClerkITV{T}VPxPEr#BPodU{VrT>EDM:SELECTNAME,JOB,YEARSFROMSTAFFWHEREDEPT=ORDERBYNAMEKodzzBPa{:NAMEJOBYEARSDavisSalesEdwardsSalesGafneyClerkQuillMgr}XPCSELECTod,zIk*XXE"#}g,STAFFPvdP`NPvKvEEDDEPTP,TvdP`NPvKv$wwDJOBP#*{}XP,ZSELECTSdOCDISTINCT!n#}g,g{DISTINCTekCod,rEPDn$wvPvN:SELECTDISTINCTDEPT,JOBFROMSTAFFWHEREDEPT<ORDERBYDEPT,JOBKodzzBPa{:DEPTJOBM

用户评论(0)

0/200

精彩专题

上传我的资料

每篇奖励 +2积分

资料评价:

/26
仅支持在线阅读

意见
反馈

立即扫码关注

爱问共享资料微信公众号

返回
顶部