select CurData,GetTimestamp from HISDATA
where gettimestamp in (
select MIN(gettimestamp) from HISDATA
where gettimestamp >= '2023-05-01 00:00:00' and gettimestamp < '2023-05-10 00:00:00'
group by DATEADD(day,datediff(day,0,gettimestamp),0))
order by GetTimestamp
获取每天的第一个数据的示例。