SELECT a.LOCATION_AREA_CODE, a.PROVINCE, a.CITY, a.AREA, a.IS_AUTHORIZED, a.VISIT_TIME FROM stranger_access_record AS a where a.DEL_FLAG=0 and date_sub(curdate(), interval 3 day) <= a.VISIT_TIME ORDER BY a.VISIT_TIME desc
sql查询最近三天的数据
最新推荐文章于 2024-07-18 03:58:29 发布