作者arianda (火锅)
看板PHP
标题Re: 如何选出上传时间最晚（最新）的一笔资料
时间Wed Feb 13 14:24:27 2008
※ 引述《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
1F：推 ntouckcm:无法送出You have an error in your SQL syntax. 02/13 14:34
2F：→ ntouckcm:Check the manual that corresponds to your MySQL 02/13 14:35
3F：→ ntouckcm: server version for the right syntax to use near 02/13 14:36
4F：→ ntouckcm:'SELECT MAX(`lab_upload_info`.UploadTime ) AS Lastest 02/13 14:36
5F：→ ntouckcm:_UploadTIME 02/13 14:36
6F：推 ntouckcm:我ORDER BY把AND改成,就可以了谢谢大家那麽热心 02/13 14:45
7F：→ arianda:我忘记要新一点版本mysql才能用子查询.... 02/13 14:48