SQL中怎么查询出时间最大的那条记录啊?句子该怎么写?OPERATESTATELEVELDATE21202012-12-2210:05:143102012-12-2210:06:2052502012-12-2210:06:3661502012-12-248:16:05

Question

SQL中怎么查询出时间最大的那条记录啊?句子该怎么写?
OPERATE STATE LEVEL DATE
2 1 20 2012-12-22 10:05:14
3 1 0 2012-12-22 10:06:20
5 2 50 2012-12-22 10:06:36
6 1 50 2012-12-24 8:16:05

Answer 1

SELECT
*
FROM
表
WHERE
DATE = ( SELECT MAX( DATE ) FROM 表 )