Newest or oldest insertion

[jackzampolin]

@Indeed_1 The first and last functions are what you are looking for

select last(*) from cpu where time > now() - 1m
select first(*) from cpu where time > now() - 1m