How to get the latest only records in table , using influxdb as datasource

hi , i have multiple sets of records like the following , im using Table panel in grafana , using the influx 1.7.8

site player name player Score
Site1 john 12
site2 Dennis 13
site3 walker 11
Site1 john 10
site2 Dennis 11
site3 walker 9

is it possible to show only the latest record for each site, i have tried limit option but it shows only the last 3 records not the latest

You can achieve this by combining last() and “group by”.
Something like…
SELECT last(score) from measurement group by *
…should work.

Use field values in the last()-function and tag values in group by.