作者查詢 / lilicoco520

總覽項目：發文 | 留言 | 暱稱

作者 lilicoco520 在 PTT [ Database ] 看板的留言(推文), 共8則

限定看板：Database

看板排序：

全部AmuroNamie4359Japan_Travel1924Soft_Job442J-PopStation298SET184Gossiping150Japandrama130MakeUp115Hamster107BeautySalon96HsinYi71movie66rent-exp60WomenTalk56Ayu52FITNESS46DC41Utada41creditcard40joke34Kaohsiung34Lifeismoney31stationery31GraduateCram30EatToDie26Polytechnic26Romances25Printer_scan21CVS20MobileComm19Sony-style19marvel18Tech_Job17fatworld16cookclub14Finance14Salary14Brand13globe12CareerLady10Food9Stock9Database8Drama-Ticket8MobilePay8PublicIssue8DailyArticle7Hate7Insurance7iOS7KodaKumi7LivingGoods7DSLR6home-sale6Japan_Living6StupidClown6CareerPlan5e-shopping5Anti-Cancer4Jolin4media-chaos4NIHONGO4TaylorSwift4TOEIC4C_Chat3ck60th3073fastfood3JapanIdol3L_Traveling3SHENA-RINGO3Shu-Lin3ShuangHe3SongShan3TY_Research3Arashi2Aviation2CYUT2DC_SALE2Doraemon2FLAT_CLUB2Golden-Award2HarukiMuraka2Ind-travel2mknoheya2Plant2PttCard2Railway2SYSOP2Theater2WTUC_talk2YP95-3112AquaTimez1ASHS-93-li1ask1BeautyBody1Boy-Girl1BuyTogether1Bz1Cancer1cat1Cheer1Christianity1CHSH-3191ck49th3101ck58th3021CKMB1coincidence1CSMU-MIS951ELT1Evangelion1firsttime1FTHS-1581gift1graduate1Jacky1JP_Entertain1kindness1kobukuro1KS94-3021KS95-3021KS96-3141KUAS1L_TalkandCha1LArc-en-Ciel1LUNA_SEA1MayDay1MihoNAKAYAMA1Mo-Musume1MoveHouse1MrChildren1MuscleBeach1N-E-W-S1NCCU08_LawA1NCCU08_LawB1NCU97ME-B1NCUIM951NDMC-P921NDMC-PH231NTCUST1NTNU-SLM951NTPU-PAGE961NTUE-CS981NTUmed911NYUST98_FING1OtsukaAi1points1PublicServan1PushDoll1SPEED1SSSH-16th-Fk1Starbucks1Steam1STU1TA_AN1Tainan1Taoism1Teacher1TFSHS66th3201TKU_GF_OB1TTSH12th3091TuTsau1Unique_Mika1V_ScHooL1visualband1w-inds1You_out1YP94-3021YUI1ZARD1<< 收起看板(169)

首頁

尾頁

[SQL ] 想要 group by 資料，內含 null

[ Database ]5 留言, 推噓總分: +3

作者: paranoia5201 - 發表於 2020/03/12 21:14(5年前)

3^F推lilicoco520: 為什麼null可以跟FB合在一起？是只要Anne但channel為03/17 22:22

4^F→lilicoco520: null的都歸入FB?如果是，可以先將資料nvl(channel,’03/17 22:22

5^F→lilicoco520: FB')，再group by03/17 22:22

[SQL ] SQL欄位中的資料選擇

[ Database ]3 留言, 推噓總分: +1

作者: fall199721 - 發表於 2019/10/28 16:12(6年前)

2^F推lilicoco520: 都會有逗號嗎？先依照逗號切割成三部分塞到新的table10/31 03:27

3^F→lilicoco520: ，再做後續統計。10/31 03:27

[SQL] 取數個最新卻不重複的資料

[ Database ]5 留言, 推噓總分: +2

作者: yuoo1580 - 發表於 2018/11/26 17:29(7年前)

2^F推lilicoco520: 可以看一下 row_number() over (partition by abc類12/02 07:19

3^F→lilicoco520: 別欄位名稱 order by 時間欄位名稱），再挑出row_num12/02 07:19

4^F→lilicoco520: ber是1的即可12/02 07:19

首頁

尾頁