[SQL袖珍参考手册(第3版)].(SQL.Pocket.Guide).Jonathan.Gennick.文字版

《[SQL袖珍参考手册(第3版)].(SQL.Pocket.Guide).Jonathan.Gennick.文字版》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、SQLPocketGuideTHIRDEDITIONSQLPocketGuideJonathanGennickBeijing•Cambridge•Farnham•Köln•Sebastopol•TokyoSQLPocketGuide,ThirdEditionbyJonathanGennickCopyright©2011JonathanGennick.Allrightsreserved.PrintedintheUnitedStatesofAmerica.PublishedbyO’ReillyMedia,Inc.,10

2、05GravensteinHighwayNorth,Sebastopol,CA95472.O’Reillybooksmaybepurchasedforeducational,business,orsalespromo-tionaluse.Onlineeditionsarealsoavailableformosttitles(http://my.safaribooksonline.com).Formoreinformation,contactourcorporate/institutionalsalesdepartm

3、ent:(800)998-9938orcorporate@oreilly.com.Editor:JulieSteeleCopyeditor:TeresaElseyProductionEditor:TeresaElseyProofreader:EmilyQuillIndexer:EllenTroutmanZaigCoverDesigner:KarenMontgomeryInteriorDesigner:DavidFutatoIllustrator:RobertRomanoPrintingHistory:March20

4、04:FirstEdition.April2006:SecondEdition.November2010:ThirdEdition.NutshellHandbook,theNutshellHandbooklogo,andtheO’ReillylogoareregisteredtrademarksofO’ReillyMedia,Inc.ThePocketGuideseriesdesig-nations,SQLPocketGuide,theimageofachameleon,andrelatedtradedressar

5、etrademarksofO’ReillyMedia,Inc.Manyofthedesignationsusedbymanufacturersandsellerstodistinguishtheirproductsareclaimedastrademarks.Wherethosedesignationsappearinthisbook,andO’ReillyMedia,Inc.,wasawareofatrademarkclaim,thedesignationshavebeenprintedincapsoriniti

6、alcaps.Whileeveryprecautionhasbeentakeninthepreparationofthisbook,thepublisherandauthorassumenoresponsibilityforerrorsoromissions,orfordamagesresultingfromtheuseoftheinformationcontainedherein.ISBN:978-1-449-39409-7[TG]1288815268ContentsSQLPocketGuide1Introduc

7、tion1AnalyticFunctions7CASEExpressions:Simple7CASEExpressions:Searched7CASTFunction8CONNECTBYQueries8DataTypeConversion15DataTypes:BinaryInteger15DataTypes:CharacterString15DataTypes:Datetime16DataTypes:Decimal19DatetimeConversions:DB221DatetimeConversions:MyS

8、QL24DatetimeConversions:Oracle28DatetimeConversions:PostgreSQL31DatetimeConversions:SQLServer34DatetimeFunctions:DB238DatetimeFunctions:MySQL39DatetimeFunctions:Oracle40DatetimeFun