SELECT
id,name,price
FROM
mst_item
WHERE
id IN (
SELECT
CASE
WHEN SIGN(id - 7) > 0 THEN MIN(id)
WHEN SIGN(id - 7) < 0 THEN MAX(id)
ELSE id
END AS id
FROM
mst_item
GROUP BY
SIGN(id - 7)
)
ORDER BY
id ASC;
sign(X)函数返回X的符号(负数,零或正)对应-1,0或1