[SQL袖珍參考手冊(cè)(第3版)].(SQL.Pocket.Guide).Jonathan.Gennick.文字版

《[SQL袖珍參考手冊(cè)(第3版)].(SQL.Pocket.Guide).Jonathan.Gennick.文字版》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在學(xué)術(shù)論文-天天文庫。

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