资源描述:
《SQL语句面试题范文.doc》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、1.一道SQL语句面试题,关于groupby表内容:2005-05-09胜2005-05-09胜2005-05-09负2005-05-09负2005-05-10胜2005-05-10负2005-05-10负如果要生成下列结果,该如何写sql语句? 胜负2005-05-09222005-05-1012------------------------------------------createtable#tmp(rqvarchar(10),shengfunchar(1))insertinto#tmpvalues('2
2、005-05-09','胜')insertinto#tmpvalues('2005-05-09','胜')insertinto#tmpvalues('2005-05-09','负')insertinto#tmpvalues('2005-05-09','负')insertinto#tmpvalues('2005-05-10','胜')insertinto#tmpvalues('2005-05-10','负')insertinto#tmpvalues('2005-05-10','负')1)selectrq,sum(casewhensheng
3、fu='胜'then1else0end)'胜',sum(casewhenshengfu='负'then1else0end)'负'from#tmpgroupbyrq2)selectN.rq,N.勝,M.負from(selectrq,勝=count(*)from#tmpwhereshengfu='胜'groupbyrq)Ninnerjoin(selectrq,負=count(*)from#tmpwhereshengfu='负'groupbyrq)MonN.rq=M.rq3)selecta.rq,a.a1胜,b.b1负from(selectr
4、q,count(rq)a1from#tmpwhereshengfu='胜'groupbyrq)日本发动了蓄谋已久的侵华战争.这场侵略战争给中国人民带来了空前的灾难和损失,也给后人留下了深刻的历史血鉴ofsupportandhanger.Cableholeplugginggapsshouldusequalifiedfireproofmaterials,blocksurfaceshouldhavesufficientstrength,surfaceappearance.Whencablespassthroughthefirewall,ofl
5、axstructureoflocalfiresafetyclamps.Thermoplasticsproduction,tocomplywiththeprocess,nobubblesinthethermoplasticspipes,linearnoseconsistentwiththecorewirespecifications,contactisgood,nocracks,break.Tinnedcoppernosecleansolderfullexteriorsurfaceissmoothwithoutburrs.Controlc
6、ableAssemblyshouldbefastened,dense,solid,clean,andbeautiful.Secondarywiringthecableterminationsshouldbearrangedbytheactuallocationofthedevicelinecards,thewiringfromtheuppertothelower,fromlefttorightintheorder.Fixedtomaintainconsistentspacingbetweenlines,flat,shouldbearou
7、ndthecornerinthesamelocation,sameshape,toensurethatthewiringprocessneaterandmoreelegant.5thermalprocesscontrolmeasuresforqualityproblems5.1controlthermalductsystemleakagemeasuretoensurethattheuseofelectricdoorandactuatorinstallationqualityandequipmenttothesitetocheckitss
8、eal,acceptance,inordertofundamentallysolveoilspillproblems.PlantforlocalPanelafterinstallation,inconjun