作者查詢 / olycats

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

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

限定看板：Database

看板排序：

全部Wen-Shan1093Map-Guide742NCCU06_Stat486PokemonGO165Bus140NCCU07_Stat139NCCU137TY_Research120fastfood116NCCU08_Stat106Zhongzheng105HsinTien95Drink86Office81MRT75Soft_Job75HSNU_109969Salary58hypermall52HSNU_NCCU50L_TaiwanPlaz43creditcard42cookclub41HsinYi41NCCU05_Stat39Python38Gossiping35Statistics33Visual_Basic32TAXI27marvel26CareerLady25NCCU09_Stat25ask22love-vegetal22Daan21Grad-ProbAsk19toberich16Bank_Service15Database15ShuangHe15feminine_sex14SongShan14StupidClown13Taipei13rent-exp12Road11homemaker10Shu-Lin10MakeUp9MobileComm9MobilePay9PuzzleDragon9SENIORHIGH9L_LifePlan8SYSOP8underwear8BusTimes7Emergency7HsinChuang7juniorhigh7Neihu7Anti-ramp6Apay6BigBanciao6EatToDie6firsttime6GetMarry6L_ShoppingMa6Aviation5CodeJob5graduate5home-sale5Japan_Travel5MIS5stationery5SuperIdol5TOEIC5AskBoard4bag4BigSanchung4Bunco4Datong4HSNU_FuBoard4JOB-Hunting4nb-shopping4NCCU04_Stat4puzzle4Windows4AnimalForest3Browsers3Eng-Class3EZsoft3Facebook3FJU3Food3FoodDelivery3hairdo3NCCU_BEAUTY3SK_SD_PL3Sony-style3Supermission3WuGu-BaLi3Beauty2Bioindustry2CareerPlan2Contacts2DailyArticle2drawing2FJU-ACCR942Health2HSNU_10632Instant_Mess2Lifeismoney2Math2nCoV20192NDHU_MSE962Olympics_ISG2PH-sea2Programming2PublicBike2Railway2Russian2Tea2Tech_Job2wonfu2Actuary1Android1AT_PingPong1barterbooks1BeautySalon1book1Boy-Girl1Broad_Band1CATCH1CFAiafeFSA1CompBook1CS_Basket1CTSH91-3021CVS1FacebookBM1FJU-BA94B1Geography1GFonGuard1GreenParty1HSNU_10361HSNU_10521HSNU_10551HSNU_10571HSNU_10701HSNU_10771HSNU_10921HSNU_10951HSNU_11501HSNU_9291HSNU_9471HSNU_9531HSNU_9581HSNU_9611HSNU_9751HSNU_9761HY29th3071Keelung1Key_Mou_Pad1L_LifeInfo1Lawyer1logic1lostsleep1MCU_Talk1Nangang1NCCU03_FM1NCCU07_CHI1NCCU07_PHILO1NCCU08_Arab1NCCU08_CHI1NCCU08_EcoG1NCCU08_PHILO1NCCU08_RMI1NCCU09_Arab1NCCU09_LawA1NCCU09_LawB1NCCU09_LawC1NCCU09_MAT1NCCU09_Math1NCCU09_SOCI1NCCU10_CHI1NCCU10_LawA1NCCU10_LawB1NCCU10_LawC1NCCU_Exam1NCCU_Info1NCCU_mathG971NCCU_NICEBOY1NCCU_PFBASE1NCCU_SHUAI1Nethood1NTUE-DC991NTUST-CE-M961NTUST-ECE1NTUT_CH585A1Policy1RSSH91_1081San-Ying1Scorpio1ServiceInfo1Songs1specialman1Stock1taipin3261Taoyuan1tutor1Violation1WomenTalk1Zhongshan1<< 收起看板(214)

首頁

尾頁

[問題] 既然有資料表了為何還要建檢視表 (View)

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

作者: rrr0832 - 發表於 2020/05/13 17:35(5年前)

4^F→olycats: 舉例若有好幾十支程式都用到這個資料05/14 01:49

5^F→olycats: 多包一層view可以減少麻煩如果要改邏輯只要改view就好05/14 01:49

6^F→olycats: 不需要幾十個地方都一起改05/14 01:50

[SQL ] 如何判斷語法在環境中的可行性？

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

作者: paranoia5201 - 發表於 2019/08/10 22:20(6年前)

1^F→olycats: 不會有這個困擾耶…噴錯誤的時候就會懷疑沒支援了08/16 03:09

2^F→olycats: 用久了大概都知道哪些語法比較特殊各資料庫用法不同08/16 03:10

3^F→olycats: 要用的時候都會先查一下例如 rank over MySQL08/16 03:12

4^F→olycats: 確認可以才會用更何況還有資料庫版本的問題08/16 03:13

[SQL ] 同時列出最資淺與最資深員工於1 query

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

作者: AmigoSafin - 發表於 2019/07/14 10:49(6年前)

3^F→olycats: 錯誤訊息的意思是07/15 18:48

4^F→olycats: RITDB_employee這個table找不到名稱為YRSEXPEEIENC的欄位07/15 18:48

5^F→olycats: E07/15 18:48

6^F→olycats: *找不到名稱為YRSEXPERIENCE的欄位07/15 18:49

[SQL ] 使用top 1 取hire_date最早的資料

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

作者: AmigoSafin - 發表於 2019/07/14 09:50(6年前)

3^F→olycats: 我記得oracle沒有top的語法吧！？07/15 16:23

[SQL ] DB2將多列資料轉成一筆Column的做法...

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

作者: dontbirdme - 發表於 2019/03/16 22:37(6年前)

1^F→olycats: https://reurl.cc/xaArz03/20 13:17

2^F→olycats: 沒用過DB2但有查到這兩種方法，請問可行嗎？03/20 13:18

[SQL ] Select where 遇到 null 時會被自動去掉

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

作者: otyootyo - 發表於 2012/02/23 19:13(14年前)

10^F推olycats:真的耶每次遇到null都很頭大02/23 23:20

首頁

尾頁