Re: 如何選出上傳時間最晚（最新）的一筆資料

[arianda (火鍋)]

※ 引述《ntouckcm (知足常樂)》之銘言：
: 資料表
: UserName   LAB_Id   FileName    UploadTime
: B94570122  lab2_1   view.c      2008-02-13 10:30:27
: B94570122  lab2_1   texture.c   2008-02-13 10:30:08
: B94570122  lab1_1   simple.c    2008-02-13 11:09:30
: B94570122  lab1_1   wind_mill.c 2008-02-13 13:34:24
: B94570122  lab1_1   light.c     2008-02-13 10:31:28
: 請問語法如何選　
: 從lab1_1挑出最新一筆上傳的檔名wind_mill.c和lab2_1的view.c？
: 剛學ｍｙｓｑｌ不久，請大家告訴我謝謝！

SELECT LAB_Id, FileName, UploadTime
FROM `LAB_Upload_Info` b
RIGHT JOIN (

SELECT MAX( `LAB_Upload_Info`.UploadTime ) AS Lastest_UploadTIME
FROM `LAB_Upload_Info`
GROUP BY `LAB_Upload_Info`.`LAB_Id`
ORDER BY `LAB_Upload_Info`.`UploadTime` DESC
)a ON a.Lastest_UploadTIME = b.UploadTime


結果是
LAB_Id  FileName  UploadTime
lab1_1 wind_mail.c 2008-02-13 13:34:24
lab2_1 view.c      2008-02-13 10:30:27


不知道這樣對不對

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 60.250.32.15
推 ntouckcm:無法送出You have an error in your SQL syntax.
→ ntouckcm:Check the manual that corresponds to your MySQL
→ ntouckcm: server version for the right syntax to use near
→ ntouckcm:'SELECT MAX(`lab_upload_info`.UploadTime ) AS Lastest
→ ntouckcm:_UploadTIME
推 ntouckcm:我ORDER BY把AND改成,就可以了謝謝大家那麼熱心
→ arianda:我忘記要新一點版本mysql才能用子查詢....