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'))