SQL 最大值的方法

SELECT *
FROM PMS_log
WHERE (ROOM_NO = '0918') AND (DAT > '2006-11-30')

INSERT INTO PMS_log
      (ROOM_NO, TYP, OK, DAT, NOTE, TEL_CLASS)
VALUES ('0918', '4', '0', '2006-12-01', 'TEL CLASS:0', '0')

最大值的方法
　　select e_name
　　from employee
　　where e_wage =
　　(select max(e_wage)
　　from employee)

SELECT ROOM_NO, TYP, OK, DAT, NOTE, TEL_CLASS
FROM PMS_log
WHERE (REC_NO =
          (SELECT MAX(rec_no)
         FROM pms_log
         WHERE ROOM_NO = '6789'))