Is there a way to grab the timestamp of a record when using DISTINCT()?

,
1

I really do need the actual time stamp of a record, but it seems like DISTINCT() returns 0 or a lower bound for time.

If it’s not possible with DISTINCT, is it possible to do some select magic and get it so that I only get unique values based on a column?

Also I need other columns, besides the unique values.

2

select * from <measurement> group by <field> order by time desc limit 1 sort of does what I want.