作者查詢 / howardandy
作者 howardandy 在 PTT [ Database ] 看板的留言(推文), 共19則
限定看板:Database
看板排序:
全部C_Chat1501CFantasy487FATE_GO324ChainChron308TypeMoon302BlackDesert274Steam259Gossiping252Taurus241FBG229GirlsFront226Bank_Service170SummonersWar151SummonsBoard151Soft_Job137Arknights127mobile-game126home-sale125PlayStation104Stock98Old-Games79Finance75XBOX73NSwitch67Salary64AnimalForest56pal53MabinogiDuel36WorkinChina35joke34Gamesale33StupidClown32Mabinogi30Koei29Falcom24MiHoYo22MobileComm22Sheena21biker20Chan_Mou19Database19feminine_sex19PM19creditcard16Mist_Mobile16Tech_Job16C_Sharp12Web_Design12CrashFever11LineageII10TerraBattle10Tine_OPTC10Anti-ramp8Sijhih8GVOnline7NY-Yankees7cat6CMWang6MRT6DiabloEX4ONE_PIECE4Sub_GMobile4Tera4AC_In3AllTogether3Crusaders3Emergency3FireEmblem3Hearthstone3movie3BlueArchive2e-shopping2FCU_Talk2FITNESS2H-GAME2MH2part-time2Tainan2Aries1Army-Sir1Cavaliers1Conan1CSMU-TABLEte1DIABLO1HatePolitics1HCSHch13_3111HsinYi1KHCHS-93-3091KS97-3161Lifeismoney1Marginalman1NARUTO1NCHU_APM1001Neihu1NKFUST-CCE901NTUCL-BASKET1NTUIB021NTUSTfinM971NTUT_IPET4951Paradox1Post1RedSox1Shadowverse1SOFTSTAR1street_style1TTU-AFL1WarCraft1Windows1Yup01-041<< 收起看板(109)
首頁
上一頁
1
下一頁
尾頁
1F→:有了ORDER ON 去 關聯表找 PROD NO 後利用PROD NO 找04/07 18:46
1F→:where B in ㄅㄆ and A in b c (再不行+SubQ)12/19 19:20
1F→:Trigger12/12 02:06
1F→:一般而言C應該就是NTFS了,反安裝移除不乾淨嗎?08/30 03:23
1F→:應該要說看公司,目前看過db2 tsql plsql ..08/15 12:54
3F→:初學小弟建議這個 www.1keydata.com/tw/sql/sql.html08/15 17:33
2F→:改這樣是更精煉..而已= =08/08 00:35
5F→:那我幫不上了QQ..我也一直都在玩oracle 請access的人囉08/08 01:13
1F推:(procedure + temp table) or ( Excel 的 CONCATENATE)07/07 11:02
2F→:那就組字串 變數有3 for下去跑 用字串陣列or..方式滿多07/07 11:29
4F→:囧? 我覺得這不是怎寫的問題了@@ 限制是啥? 連字串都07/07 12:58
5F→:那請問您本文中的Update 怎接在Select後面的@@"?07/07 15:54
1F推:把上面當子查詢 group by 後 count 然後排序count07/06 16:34
2F→:當子查後排序由大到小,取第一行uid07/06 16:41
1F推:如果是Oracle我這邊倒是有遇過這種例子也解過..07/02 21:20
2F推:oracle 表中亂碼 是client use big5 add to db utf807/02 22:48
1F推:SUBSTR(NAME,0,LENGTH(NAME)-2) AS NEWNAME06/21 10:12
4F→: 恩,若最後不是固定兩碼,pos就要派上用場了06/22 12:32
6F→:position 我MS用法很久沒用了 不熟,下面寫法你參考06/23 01:57
首頁
上一頁
1
下一頁
尾頁