作者查詢 / tedcat
作者 tedcat 在 PTT [ Database ] 看板的留言(推文), 共104則
限定看板:Database
看板排序:
全部Stock1049Headphone910car671outdoorgear558creditcard480PC_Shopping350AntiVirus321movie191Steam176watch169SkiSnowboard145MobileComm122Database104hardware92EZsoft85Navy72Storage_Zone67VideoCard52pal40Browsers39ask36AllTogether35NTUBA94study26ck53rd31622WOW22Wanhua20Lineage18magic_silver18NtuDormM517DIABLO16GuildWars15Web_Design15MacGyver14Cloud13LCD12SNSD11TVCard11cat10Visual_Basic10Keelungfan9OTT9Digital_Art8NtuDormM38e-shopping7Gossiping7Volleyball7OverClocking6CAR-TUNING5PttLaw4CarShop3Hate3IME3Printer_scan3cksh79th062H-GAME2HardwareSale2java2Network2NTUE-CEE972NTUST-EE-B912P2PSoftWare2PHP2sex2SYSOP2Alec_Su1AppsForBBS1Audiophile1AudioPlayer1AVEncode1biker1BLEACH1C_BOO1C_Chat1C_Sharp1Capricornus1CD-R1ck54th3301cksh78th031CLAMP1D-grayman1DC1Dynasty1ESOE-921ESOE-951Examination1exchange_3C1EYESHIELD211FJU-AM-901FJU-Trade1friends1Gov_owned1HBB7151HSNU_10601Info_96-11Instant_Mess1JA31th3241Key_Mou_Pad1KG88-3101KOTDFansClub1L_LifePlan1Lifeismoney1NTHUEE021ntnuch92b1NTUBA951NTUBST981NTUBST991NTUcourse1NtuDormM81NTUot911NTUot921NUU_Talk1ouran_hosuto1Perl1PhotoLink1PHX-Suns1PlayStation1PublicServan1PuzzleDragon1Road1share1Sodagreen1Stephen1TaichungBun1Taiwanlit1tale1Tech_Job1Theater1Trace1TWopera1TYSH49-3031Wallpaper1WangChieh1<< 收起看板(132)
4F→: 另外一個方式是在order by自建欄位order by case when fi09/14 22:56
5F→: eld is null then 1 else 2 end asc, 然後原本欄位 desc09/14 22:56
1F→: 要先group by09/12 12:25
1F→: 做index10/23 20:57
1F→: https://ithelp.ithome.com.tw/m/articles/1021739510/04 14:16
2F→: 上面這個網址有說明day1-30的比例是怎麼計算出來的,理解10/04 14:17
3F→: 之後就可以轉成sql10/04 14:17
4F→: 好像不對。。。當我沒說10/04 14:21
7F→: 把國英數欄位拆成三個表,做union讓他變成都在一個欄位,09/30 17:13
8F→: 然後再用group by avg09/30 17:13
10F→: 推文方法2應該不可行,banana%會涵蓋g1707/12 12:39
2F→: 試試看加中括號 [a]05/04 02:17
4F→: 萬用的話是convert+substring08/18 15:32
6F→: 絕對先問資料量跟資料庫種類03/18 18:40
7F→: 這樣才有辦法決定後續的同步頻率03/18 18:42
8F→: 還有資料傳輸方式(檔案/對抄)03/18 18:43
1F→: 問題太長我回答第一個XD 兩個做法都可以。 第一個好處跟壞08/30 18:00
2F→: 處你都提到了,但確實比較直覺。 而你的做法與其分ab表不如08/30 18:00
3F→: 弄成一表 然後多一個欄位分辨乘數被乘數。08/30 18:00