SELECT MIN(date_column) AS min_date, MAX(date_column) AS max_date FROM table_name;

示例：

 SELECT MIN(zhi) AS min_zhi, MAX(zhi) AS max_zhi,jg AS jg FROM dnold_2_201 WHERE endtime BETWEEN '2023-8-1' AND '2024-4-20' and lou='二号楼' and fj='201' and jg='A18-B' and lu='B';