推 Luos: SELECT * FROM table ORDER BY record LIMIT 3 08/11 10:20
推 crossdunk: SELECT * FROM table order by gdate,score DESC 08/11 10:24
→ crossdunk: 取前三名就再加上LIMIT 3 08/11 10:24
推 Luos: ORDER BY gdate, grade DESC 08/11 10:24
→ jami520: 這樣方式好像只能取出三筆資料而已呢! 我是想要取出每天 08/11 11:47
→ jami520: 的前三筆數據,假設有五天就是會有15筆資料,然後每天用 08/11 11:47
→ jami520: 分數來做排序。 08/11 11:48
推 unarus: 既然在PHP這裡問 就放個日期參數用迴圈去查呀 08/11 12:50
推 dv2001: group by 09/07 09:11