[达梦]查询某条数据的上一条和下一条数据

上一条：

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