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

解答：具體示例如下：

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;