上一条:
SELECT TOP 1 *
FROM table_name
WHERE field_name<id_param
[other_condition]
ORDER BY table_name DESC
示例:
SELECT TOP 1 *
FROM LOG_ALARM_RECORD
WHERE ALARM_RECORD_ID<'1317750223266684930'
AND SENSOR_ID='1169143695698673666'
ORDER BY ALARM_RECORD_ID DESC
下一条:
SELECT TOP 1 *
FROM table_name
WHERE field_name<id_param
[other_condition]
ORDER BY table_name ASC
示例:
SELECT TOP 1 *
FROM LOG_ALARM_RECORD
WHERE ALARM_RECORD_ID<'1317750223266684930'
AND SENSOR_ID='1169143695698673666'
ORDER BY ALARM_RECORD_ID ASC