作者teddypig ()
看板Database
标题[SQL ] 查询最新一笔资料!!
时间Fri Nov 24 21:17:59 2006
我要找出此票号的最新一笔纪录
我的SQL语法是
SELECT MAX(in_date) AS Expr1, TWorkType_id, Bticket_Num, Eticket_Num
FROM Ticket_Manage
WHERE (Bticket_Num = '1347001') AND (Eticket_Num = '1347100')
GROUP BY TWorkType_id, Bticket_Num, Eticket_Num
但是我查出来是两笔资料
请问我哪里有出错了吗?
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.127.22.89