Query select * where unique or latest?

can I create a query that grabs all the values from say systemsample and limit it to latest\unique values only? thank you

SELECT * FROM SystemSample WHERE unique(hostname)

Hi, @jrassi: You will have to list the values you want individually:

SELECT latest(cpuPercent), latest(memoryUsedPercent), latest(diskUsedPercent) FROM SystemSample FACET hostname

ugh, ok thanks, that does seem silly, I mean it seems like an unnecessary limitation.