作者查詢 / icydream
作者 icydream 在 PTT [ Database ] 看板的留言(推文), 共6則
限定看板:Database
看板排序:
全部model1084Gossiping827Baseball303ChangHua285Vietnam228PlayStation77Soft_Job65Road_Running64MobileComm57java56NSwitch51XBOX50PSP-PSV30MP29Ajax28HHSH28Finance27PC_Shopping27iOS26CVS25NTUSTMIS_B9122Yanzi19PokemonGO17Militarylife16movie16NDS16EatToDie15car14NARUTO14SD14fashion13StupidClown13Shu-Lin12ShuangHe12SongShan12bag11creditcard11License11Modchip11PokeMon8Army-Sir7MP96-17nCoV20197Nintendo7TOEIC7Bread6CAFENCAKE6Database6Salary6Tech_Job6ANIMAX5hypermall5joke5HatePolitics4MP96-2T4specialman4bicycle3Doraemon3FITNESS3FTV3HCHS603123Lifeismoney3MapleStory3MP95-1T3shoes3TA_AN3Tyukaitiban3C_Chat2drawing2Drink2Examination2FinalFantasy2FJU-ACCR942Headphone2Kaohsiung2MAC2marriage2MLBGAME2NIU-ECE94b2Old-Games2SlamDunk2TaichungBun2TVCard2About_Life1Boy-Girl1Broad_Band1Buzz_Act1CCF1ck54th3311ck56th3241cksh85th3201CMU_M481CSMU-MED951CYCU_EE_07A1Donate-Blood1DragonQuest1DYU1Eng-Class1Football1Geotecheng961Hate1historia1home-sale1HSNU_11151Instant_Mess1Japan_Travel1KHCHS-93-3061Kindaichi_Q1KMU1KS94-3121L_RelaxEnjoy1L_TaiwanPlaz1LCD1LHU1MenTalk1MH1Monkeys1NCHU-FS1001NDMC-PH231NewAge1NKUTEE1NTPU-STAT951NTU1NTU-EM931NTU-GIIB20041NTUmed911NTUST-EE-B911NTUSTMIS_M941NY-Yankees1Olympics_ISG1ONE_PIECE1PeopleSeries1Pocket1PublicIssue1sex1SRW1Steam1Stock1STU1Tainan1TaiwanDrama1TunHua05t3111TuTsau1USC1YOLO1Yunlin1<< 收起看板(146)
首頁
上一頁
1
下一頁
尾頁
2F→: on a.aid = b.aid03/21 10:02
1F推:我的想法是,把true轉型為1, false轉型為0,然後做乘法運02/22 12:51
2F→:算,如果結果是1表示true,0表示為false。02/22 12:52
1F推:select的欄位,與group by的欄位不符02/24 17:41
2F→:改為select concat(binary bid), sum(num)試試,02/24 17:42
3F→:或是再重新調整group by的欄位。02/24 17:43
首頁
上一頁
1
下一頁
尾頁