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';

其中，table_name为表名，date_column为包含日期信息的列名。这条查询会返回两个结果，分别对应于日期范围内的最小日期和最大日期