問：如何才能查出一天中最早登錄的數據番號和最晚登錄的數據番號和時間？

解答：具體示例如下：

SELECT * FROM (

SELECT A_RENBAN,TOUROKU_DT FROM A WHERE TOUROKU_DT IN (SELECT MAX(TOUROKU_DT) FROM A GROUP BY TO_DATE(TOUROKU_DT))

UNION

SELECT A_RENBAN,TOUROKU_DT FROM A WHERE TOUROKU_DT IN (SELECT MIN(TOUROKU_DT) FROM A GROUP BY TO_DATE(TOUROKU_DT))

) ORDER BY A_RENBAN DESC;