Get top 5 values from 10 different measurements

Yes, it’s possible, but some limitations may apply (depending on the measurement name) as you need to use a regex.
Docs here.

SELECT TOP(__FieldName__, 5)
FROM /__RegexHere__/
Where __whatever__

The only other way (I’m aware of) is to write a query for each measurement.