# Show string field corresponding to the max value in table

**URL:** <https://community.grafana.com/t/show-string-field-corresponding-to-the-max-value-in-table/38942>\
**Category:** General\
**Created:** [November 6, 2020, 7:59am UTC](https://community.grafana.com/t/show-string-field-corresponding-to-the-max-value-in-table/38942 "2020-11-06T07:59:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ad11grdrt11](https://avatars.discourse-cdn.com/v4/letter/a/f9ae1b/32.png) [@ad11grdrt11](https://community.grafana.com/u/ad11grdrt11)\
**Post date:** [November 6, 2020, 7:59am UTC](https://community.grafana.com/t/show-string-field-corresponding-to-the-max-value-in-table/38942/1 "2020-11-06T07:59:28Z")

</div>

Hello!  
I need to show in grafana table field corresponding to the max value  
In sql it is something like:  
SELECT field FROM table WHERE value = SELECT MAX(value) FROM table  
How can I do this in Grafana?  
I need something as shown in the picture

 ![1111111111111111111](https://us1.discourse-cdn.com/grafana/original/2X/e/ea31a27fc6fcfac2dbaf3bd00c17db3b730668ae.png)