資源描述:
《[SQL袖珍參考手冊(第3版)].(SQL.Pocket.Guide).Jonathan.Gennick.文字版》由會員上傳分享,免費(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