select highest value in mysql

Question

So I have a database that has some values like this:

Level , Indicator

4       1
3       2
4       3
3       4
4       5
3       6

What I want to do is to select the highest level value in every indicator.

Is there any sql query that I can use that will generate a result like this?

Level , Indicator

4       1
4       3 
4       5

If not, can you help me out using php and mysqli? Thank you so much.

"what I want to do is to select the highest level value in every indicator." So why does your expected result only contain Level 4 ? — Raymond Nijland, Sep 20 '18 at 19:52
Your desired output isn't what you described in the question. Either correct the explanation, or correct the output. — Barmar, Sep 20 '18 at 19:59
The output looks like "all the rows with the highest level in the table". — Barmar, Sep 20 '18 at 19:59
Provided duplicate questions for both the text and the expected output of the question. Use whichever is convenient. — Shadow, Sep 20 '18 at 23:05

Jaydip Rakholiya · Answer 1 · 2018-09-20T19:40:00.850

2

To get Indicators having just highest level value -

select distinct Indicator, level
  from your_table
 where level = (select max(level) from your_table)

Also, you can use group by to get highest level for each Indicator value -

select Indicator, max(Level) from your_table group by Indicator

edited Sep 20 '18 at 19:40

answered Sep 20 '18 at 19:33

Jaydip Rakholiya

also you could employ window functions for operating on a set of rows and return a single value for each row from the underlying query – Victor Sep 20 '18 at 22:29

1 Answers1