select multiple rows with highest value

[BrainPill]

I have a query it goes like this:

SELECT `person_id` , MAX(exam_score) FROM `results` GROUP BY `exam_score` 

exam_score is column and some values are double

when using query above I get 1 result for each.

So if the exam_score is 10,  8, 9 , 10, 8, 5, 3 10 , 6 it does:

10, 9, 8 , 6, 5, 3

while I would want:

10,10,10, 9, 8, 8

 

 

 

Edited September 13, 2019 by BrainPill

[justsomeguy]

Group by the person.

[BrainPill]

 solved it by using 

ORDER BY person_id DESC LIMIT 6

[BrainPill]

But I want this to be selected from the same table found in multiple databases. 

Anyone got a clue how to do this?

[justsomeguy]

If you want to query multiple databases and group the results into a single result set, you need to use unions or subqueries to get the various results into a single set.

[Makwana Prahlad]

Hello,@BrainPill

Please try this query, To select multiple rows with highest value :

select * from updates where 1 group by matching having votes=max(votes) order by matching asc;

I hope above query will be useful for you.

Thank you.