作者查詢 / ji394su33000

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

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

限定看板：Database

看板排序：

全部Gossiping6447HanshinTiger730WOW318DIABLO197joke153Hunter152PlayStation131PushDoll110CFantasy85Database53Stock28car23PublicIssue23specialman23Japan_Travel22PC_Shopping22FuMouDiscuss20hypermall20C_Chat19CarShop19Baseball18Simcity17HK-movie16Salary15Neihu14ask13movie13biker12TuTsau11L_TalkandCha10Tech_Job10cookclub9home-sale9NBA9SportLottery9TAXI9Tobacco9book8Employee8Gamesale8Militarylife8Steam8FishShrimp7Keelung7sex7Shu-Lin7ShuangHe7SongShan7StupidClown7HatePolitics6kawaii6KOF6medstudent6MenTalk6MobileComm6NCYU_Fst_986Reptile6RO6Soft_Job6Aquarium5Childhood5HsinTien5LTK5NIHONGO5NTHU_pingpon5QueerHabit5RealPlaying5SuperHeroes5TigerBlue5Agronomy-874ComicHouse4EmailYang4fastfood4Garena4Hate4IA4kochikame4KS95-3184KS98-3024MH4Nantou4NetRumor4Pet_Get4PttLive4Suckgame4Teacher4Windows4Wine4AfterPhD3Anti-ramp3creditcard3CSMU-MIS963CultureShock3Doraemon3EatToDie3GUNDAM3haiku3Kaohsiung3Lifeismoney3NSYSU3NUU_Talk3Palmar_Drama3paranormal3PH-sea3pharmacist3PttHistory3RIPE_gender3Road3SMSlife3SouthPark3SuperBike3SYSOP3Tainan3TW-language3Wen-Shan3Ancient2AntiVirus2Biology2CCRomance2Christianity2consumer2CYCU_Talk2DiabloEX2DiscoveryNGC2Examination2Finance2gallantry2gay2Hualien2iOS2J-PopStation2japanavgirls2JinYong2KS92-3132Ladies_Digi2LinKou2marriage2media-chaos2model2Mudran2NTTU_CSIE992NYUST2PACERS2pet2PHAT-MEN2PhD2pts2PublicServan2rent-exp2Road_Running2SoftbankHawk2StarCraft2Suckcomic2TBBT2tyart2Wanhua2WarCraft2WorkinChina2XBOX2YOLO2Yunlin2AC_In1Agronomy-951AllTogether1Aves1Aviation1BabyFace1Battery1bicycle1BigBanciao1BikerShop1Buddhism1CareerLady1Catholic1CCSH_88_3191CCU_EPARC1CH14th3021Chan_Mou1Chiayi1China_Travel1ChungLi1ck51st3281ck57th3091CSMU-MED961CSMU-MIRS1CVS1CYCU_MIS_93A1CYSH97Y3181Digital_Art1Digitalhome1DirectSales1Disabled1DPP1DSLR1EAseries1Evangelion1EverQuest21FCSH_Club1FCU-PF20061FCU_Talk1Fencing1FinalFantasy1FireEmblem1FJU_CPSY_VL1Folklore1FSHS-95-3081Gintama1Golden-Award1GossipPicket1graduate1GreenParty1GUNNM1HCHS923161Headphone1HLHS_10thU1HOT_Game1Hsinchu1HSNU_10731HSNU_9481HSNU_9751I-Lan1ILSH-973051ILSH_923121Jacky_Woo1junji-ITO1kodomo1Koei1KOTDFansClub1KS95-3081KS96-3141KS96-3181KS98-3121LeBronJames1Linux1Live1LoL1LTJH-943061MartialArts1marvel1MATLAB1MCU_Talk1MdnCNhistory1Minecraft1MOD1mud_sanc1MusicStation1N_Masami1Nangang1NBA_Film1NCHU_AMpower1NDHU-phy961Nethood1NKUTEE1NTPU-STAT951NTPU-STAT961NTU1NTU-EM931NTU_stamp1NTUE-TGD971NTUEE1101NTUHistory021NTUHistory031NTUmed001NTUT_EE490A1NTUT_IPET4951Nubee1NUK_AC1001o-p-children1Old-Games1Olympics_ISG1ONE_PIECE1Option1OTT1OverWatch1P2PSoftWare1PingTung1PokemonGO1Poker1Policy1PttNewhand1Reli-curio1RO_Mobile1Romances1RSSH971Sangokumusou1scu_transfer1SENIORHIGH1ShowOff1SHU-JourM981Skating-Club1Softball1soho1soul1StarTrek1STDM-91-3041Stephen1Storage_Zone1Sub_GOnline1SurvivalGame1TA_AN1TaichungBun1Taoism1Taoyuan1Tea1Tennis1TFSHS65th3151THU_BA20001THUIM-5th1TKU_BF93C1TORIKO1Transport971TTU-AMath1TW_Entertain1USC1V61VAPE1Viator96Gi1VideoCard1Violation1wearefriends1WorldCup1YCSH_alumni1YP95-3131YUGIOH1YZU_CN99A1Zhongzheng1Zombie1<< 收起看板(327)

首頁

尾頁

[SQL ] SQL Select 直式資料轉橫式並逗點分隔

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

作者: elic2577 - 發表於 2022/11/22 17:16(1年前)

1^F推ji394su33000: 可惜你是2014比較麻煩 https://reurl.cc/06Zoyx11/22 17:52

2^F→ji394su33000: 這篇不錯各種都有寫11/22 17:52

[SQL ] 從Oracle資料庫撈資料，如何將中文編碼從

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

作者: lueichun - 發表於 2021/12/09 20:04(2年前)

2^F推ji394su33000: big5 換成ZHT16BIG5 或ZHT16MSWIN950 試試？12/22 14:33

3^F→ji394su33000: 其實不太懂你匯出的時候不就可以直接選編碼格式？12/22 14:34

4^F→ji394su33000: 還是不是用SQL Developer?12/22 14:35

[mysql] 能一次查詢多個表嗎

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

作者: averywu - 發表於 2021/01/06 10:17(3年前)

1^F推ji394su33000: 這種問題全部類型的資料庫都是利用系統表格01/09 11:14

2^F→ji394su33000: select * from information_schema.tables [mysql]01/09 11:15

3^F→ji394su33000: 這樣你應該可以取得你要的表的名稱再利用store01/09 11:16

4^F→ji394su33000: procedure看是寫迴圈去撈或者全部串起來塞到另一個01/09 11:17

5^F→ji394su33000: 表應該可以解決01/09 11:17

[活動]探討你可能不知道的 SQL Server

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

作者: rockchangnew - 發表於 2017/11/07 10:57(6年前)

1^F推ji394su33000: 講json嗎...?11/08 18:23

[SQL ] 多重表格找交集如何寫

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

作者: hochengyuan - 發表於 2017/03/08 13:20(7年前)

4^F→ji394su33000: 我還很菜的時候都把文氏圖印出來貼在桌邊 A_A03/26 00:16

[SQL ] 請問如何把 Table 內欄位行列作轉置?

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

作者: evantw - 發表於 2016/12/28 12:40(7年前)

7^F推ji394su33000: oracle 要11g才有pivot的樣子12/28 17:52

[徵人] 台北徵DBA

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

作者: midori8310 - 發表於 2016/12/19 00:01(7年前)

3^F推ji394su33000: 我上一份就是綁在一起做到最後都做BI剩下都routine12/28 17:54

[SQL ] select * from A,B where A.id=B.id

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

作者: kisha024 - 發表於 2013/09/26 10:59(10年前)

3^F推ji394su33000:Sybase也可以 .. 代表省略了中間Table owner的名字09/28 13:52

4^F→ji394su33000:也就是dbo09/28 13:52

5^F→ji394su33000:應該是TSQL的恩~ 優點??09/28 13:53

6^F→ji394su33000:因為你帳號權限夠高我猜你是sa權限如果有分權限09/28 13:55

7^F→ji394su33000:而你的權限不夠這樣打就會報錯了09/28 13:56

[SQL ] GROUP BY 年/月

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

作者: LaPass - 發表於 2013/09/23 14:36(10年前)

4^F→ji394su33000:group by 似乎不能用別名09/28 14:01

Re: [SQL ] 一次把某個欄位值全部乘以2

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

作者: cleanwind - 發表於 2013/09/20 07:43(10年前)

2^F→ji394su33000:都沒有版主了我當初也被刪過哪 qq09/28 14:04

首頁

尾頁