作者查詢 / hmsDEBBIE

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

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

限定看板：Database

看板排序：

全部home-sale1071WomenTalk577Boy-Girl560nCoV2019405Salary304Cancer248Tech_Job246teeth_salon203Gossiping156marriage156NTUcourse144studyabroad144NTUMT-00138iOS130TaichungBun113movie101GetMarry98Liang_23rd97Bioindustry82CareerPlan82DistantLove78EAseries74feminine_sex73Soft_Job67CFP58Car-rent53Kaohsiung53NTUMT-0153Japan_Travel50stationery46NTU43TOEFL_iBT43MAC42Railway40JD_Lover35Loan35GRE34Thailand33TVXQ32JJ31graduate30BCumberbatch27RESIT27UK_Actors27Hsinchu26WorkinChina26MBA21Digitalhome20Interior20Korea_Travel20FITNESS19Hong_Kong19SMSlife17SummerCourse16Virgo16NTUMT-9915Neihu14Database13MCBadminton13TY_Research13MCAthletics12SENIORHIGH12StupidClown12CareerLady11MakeUp11facelift10NTU-Exam10SpaceArt10HomeTeach9E-appliance8NTU_SKY8Olympics_ISG8e-shopping7Eng-Class7Instant_Mess7JYJ7Oversea_Job7sex7Theater7Baseball6Foreign_Inv6NTUCH-1036NTUMT-SA6QueerHabit6TWHiddleston6joke5NTUEngDeb5NTUMT-985TransBioChem5KoreaDrama4Language4MacShop4Marketing4NTU_CK_TFG4NTUmed004PttLifeLaw4CATCH3China_Travel3Conan3CSMU-MED993DoubleMajor3FTISLAND3LightNovel3NTUAC1003NTUmed973NTUmed983NTUmed993NTUMUN3P_Management3PttNewhand3Russian3Agronomy-972B003022XX2Beauty2Broad_Band2Capricornus2esahc2GFonGuard2Hotel2HyunBin2ICtribe2Ind-travel2Key_Mou_Pad2KoreaStar2Laser_eye2LifeSci_1002lyrics2MACAU2Mix_Match2NTU_BOTDorm2NTU_BOTDorm22NTUAC992ntuACCT002NtuDormF12NtuDormF22NTUHistory972NTUIM-192NTUIM-202NTUJapan082NTUMath992NTUMEB972NTUmed962NTUMSE-982rent-exp2Singapore2sungshan2TaichungCont2VET_992AGEC1001AGEC1011ask1Aviation1B001010XX1B00303XXX1B00310XXX1B01303XXX1b014060XX1B97303XXX1B97A011XX1b982040XX1B98305XXX1b98610xxx1B98A012XX1B99303XXX1b99610xxx1BoardGame1Buddhism1Channel_V1civil961civil971Daan1DataScience1EngTalk1ESOE-961ESOE-971Examination1FixMyHouse1GameDesign1geography1011geography1041geography1051GMAT1hairdo1HarryPotter1HPAIR1Japandrama1JapanIdol1LifeSci_991LivingGoods1LS_Zoology1Management1MED_Service1medstudent1MenTalk1MusicGame1nb-shopping1NSYSU1NTU-KS1NTU-Textbook1NTU10DFLL1NTUAC1011NTUAC961ntuACCT021ntuACCT961ntuACCT971ntuACCT981ntuACCT991NTUBA011NTUBIME-1031NTUBSE-B-961NTUBSE-B-981NTUBSE-B-991NTUBST1001NTUCE-1021NTUdent951NTUdent981NTUdent991NTUDFLL-MA991NtuDormF31NTUDormF41NtuDormF61NTUDormG11NTUDormG31NtuDormM21NtuDormM41NTUDormM61NtuDormM81NTUdrama011NTUDrama981NTUDrama991NTUfin001NTUHistory001NTUHistory011NTUHORTI981NTUIB011NTUIB031NTUIB041NTUJapan121NTUMath1011NTUmed011NTUMSE-971NTUMT-961NTUMT-971NTUot1NTUphy981NTUphy991NTUPiano1NTUPPM-971NTUPPM-991phys981PM1Psychology001Psychology981PT-981PttEarnMoney1rain1Rent_apart1Sagittarius1Salesperson1score1Statistics1TaiwanDrama1tax1THSRshare1underwear1Zhongzheng1ZooStudy1<< 收起看板(267)

首頁

尾頁

[SQL ] 用like連兩張表的問題

[ Database ]17 留言, 推噓總分: +6

作者: azzc1031 - 發表於 2020/06/19 11:47(5年前)

17^F推hmsDEBBIE: 先用substr及group by處理表2的料號欄位，再來join07/29 23:25

[SQL ] 訂單資料統計

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

作者: yimean - 發表於 2020/03/10 15:46(5年前)

1^F推hmsDEBBIE: target table 欄位請解讀一下，總量是什麼？03/25 19:18

2^F→hmsDEBBIE: 是訂單數量總和還是出貨數量總和？03/25 19:19

3^F→hmsDEBBIE: 另外target table 的品名欄位為何文字數字摻雜...03/25 19:19

[SQL ] 2700萬筆資料做group by

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

作者: ctr1 - 發表於 2020/01/19 22:30(6年前)

6^F推hmsDEBBIE: 先找出distinct user_id再一一進行每年每月每日的group03/22 23:47

7^F→hmsDEBBIE: by03/22 23:47

[SQL] 重複資料的移除問題

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

作者: giveadamn - 發表於 2020/01/21 11:40(6年前)

8^F推hmsDEBBIE: 疑問同樓上，你的資料是不是需要一欄insert_date，然03/22 23:45

9^F→hmsDEBBIE: 後ranking時order by insert_date desc 取最新一筆03/22 23:45

[SQL ] create table後資料遺失請益

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

作者: smile0803 - 發表於 2020/03/22 00:48(5年前)

3^F推hmsDEBBIE: 推樓上，請試試create multiset table以及改成union al03/22 23:43

4^F→hmsDEBBIE: l03/22 23:43

[SQL ] 考題語法請教

[ Database ]16 留言, 推噓總分: +4

作者: paranoia5201 - 發表於 2019/06/11 23:52(6年前)

14^F推hmsDEBBIE: 你串表要from a join b on a.ID=b.ID 而不是直接寫from06/16 22:19

15^F→hmsDEBBIE: a, b06/16 22:19

16^F→hmsDEBBIE: 你更新在內文的寫錯了推iv大寫的06/16 22:20

首頁

尾頁