作者查詢 / kattte

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

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

限定看板：Database

看板排序：

全部Gossiping8786NBA5462WomenTalk1800NBA_Film1726Hate1479WOW1369Celtics1157ask913ONE_PIECE885humanity804Hunter761Chan_Mou671STREET_BALL650basketball629WarCraft599movie596Suckcomic531NARUTO527Boy-Girl512FAIRYTAIL452Soft_Job346joke323Old-Games318RayAllen313Yunlin252TW_Entertain194BLEACH190BASKET-RULES170NHU_Talk163NBAEasyChat154basketballTW137Leo121Chiayi118kekkai111FuMouDiscuss101Web_Design100JinYong94SlamDunk93Aries92PHP86Koei85Militarylife77C_and_CPP76CATCH74dog74Mind68PttLifeLaw66StupidClown64PlayStation58sex56criminology53Hearthstone53KenAkamatsu51LeBronJames50Little-Games50LoL49OgreBattle46Beauty43car42ArakawaCow40Taoyuan40OverWatch39FITNESS38Gantz38Math38Programming36handsomechef35Examination31H-GAME29NHU_CSIE29Salary28C_Sharp25Garena25marriage24Ajax23Doctor-Info23Hawks23Pisces22MiamiHeat20Dreamland19Teacher19Tech_Job19WarCraftChat17Database16MIS15Kings13Mavericks13Bucks12puzzle12C_Chat11CrossGate11Diary11Grizzlies11kotaro11Spurs11Emulator10IVERSON10java10BLAZERS9MenTalk9AndroidDev8KS98-3028UTAH-JAZZ8Azumanga7Facebook7MH7Nets7Orl-Magic7Thunder7Wizards6ChicagoBulls5CSSE5KevinGarnett5Network5Nuggets5riddle5Wallpaper5Android4CareerLady4feminine_sex4HatePolitics4home-sale4Hornets4Inference4InitialD4Jeremy_Lin4KOF4LaClippers4Linux4Minecraft4MuscleBeach4PACERS4pay_home4PingTung4rent-exp4T-mac4unemployed4VideoCard4Baseball3DIABLO3Knicks3L_TalkandCha3Lakers3pet3specialman3worldbasket3YAO3Cavaliers2China-Drama2ComeHere2comm_and_RF2CYCU_Talk2Eclipse2FJU-Laws992Haruhi2L_LifePlan2LAW2lineageW2Military2NSwitch2NTNU-HISBK2NTU2Oversea_Job2Pistons2Ptt-Charity2RTS2Sagittarius2StarCraft2StudyGroup2SuckcomicBM2Timberwolves2AfterPhD1ANIMAX1Army-Sir1BigBanciao1biker1BlizzHeroes1Broken-heart1CareerPlan1Catholic1cksh80th3071CMU_BST011cosplay1CourtBasketB1CS_Basket1CSMU_MIR_BSK1CSonline1Design1Doraemon1eSports1Finance1FreeStyle1G-S-WARRIORS1GameDesign1GO1Golden-Award1HandMade1Hayate1HBL1HK_Comics1HoneyClover1HsinYi1HSNU_10081HWSH1job1junji-ITO1KanColle1kochikame1kodomo1L_LifeInfo1LawBasketbal1LTK1Marginalman1MobileComm1NANLIN3011NBA_Fantasy1NDMC-M1061NFU1Nirvana1NoFear1Notebook1NTHUTL971NTPU-ACC-BA1NYUST1Odoko-juku1ONLINE1Oracles1Pet_Get1PHX-Suns1Raptors1RSSH94_3031SakuraWars1SchoolRumble1SENIORHIGH1Sewing1SFFamily1Sixers1SP2_Basket1SportLottery1Steam1SteveNash131Sub_GConsole1Supernatural1SuperStarAve1swim1Taitung1TigerBlue1TKU_EW94B1TPC_Police1TTU-talk1UniversityTV1VinceCarter1Wade1wisdom1YLclub1YUGIOH1<< 收起看板(256)

首頁

尾頁

[SQL ] 設計資料表的欄位

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

作者: kattte - 發表於 2015/11/28 12:23(8年前)

2^F→kattte: 我原本也是打算這樣11/28 16:17

[SQL ] 想問一下有關primary key設計的問題

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

作者: sankight - 發表於 2015/10/02 23:16(8年前)

2^F→kattte: 2較好, 如果幣別跟對應帳號要一直擴增你的1就麻煩了10/04 17:20

3^F→kattte: 好像不太對你的公司id跟幣別還有對應的銀行與帳號全都塞10/04 17:24

4^F→kattte: 在同一個table裡喔?10/04 17:24

5^F→kattte: 我沒搞清楚就回答請無視我 @@10/04 17:32

[SQL ] 如何判斷員工的年資

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

作者: HankJiang - 發表於 2015/08/04 20:05(8年前)

5^F→kattte: 年資>3 and 年資<10 這樣可以嗎08/04 22:09

6^F→kattte: 阿不好意思沒注意到是oracle08/04 22:09

7^F→kattte: oracle我不太清楚但你可以計算出他年資幾年之後指定年資08/04 22:13

8^F→kattte: 要在你設的範圍內這是可以的08/04 22:14

12^F→kattte: 我是用mysql, oracle的語法怎麼下我不清楚08/06 22:31

13^F→kattte: SELECT * FROM student WHERE (TO_DAYS(NOW()) -08/06 22:33

14^F→kattte: - TO_DAYS(`Birth_Date`)) >(40*365)08/06 22:33

15^F→kattte: 今天 - 生日 > 40*365(天)08/06 22:34

16^F→kattte: 我的資料裡面有 1982年 1950年這樣就能篩選出 1950的08/06 22:34

18^F→kattte: 不差那一天吧08/08 00:07

22^F→kattte: 不就 10 > 年資 and 年資 > 308/13 00:53

首頁

尾頁