MYSQL Query to extract to value only

Question

I want to write a mysql query that selects the final result in the figure below :

Thanks

Any solution, for this question.

Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. — Community, Jan 09 '23 at 13:04
@SelVazi , I want to select only two rows the conditions are : 1. First row is the maximum **Key** when **ID DEVICE** is 1. 2. Second row is the maximum **Key** when **ID DEVICE** is 2. But I can't use Limit!! — Mustafa, Jan 10 '23 at 05:43

score 0 · Answer 1 · answered Jan 11 '23 at 06:35

0

This may help you, Execute query as below:

SELECT * 
FROM tickets 
GROUP BY device_id 
HAVING key_field = MAX(key_field) 
ORDER BY device_id ASC

Will produce result as you expected:

Key	ID device	ticket Number
212	1	594
211	2	147

answered Jan 11 '23 at 06:35

Urja Satodiya

1

Sorry, this does not work. It's an invalid grouping query, but even if one disables ONLY_FULL_GROUP_BY, it produces an empty result. Cf. https://dbfiddle.uk/kzZw3DZJ – Bill Karwin Jan 11 '23 at 06:45
@BillKarwin This query has been executed in `sqlite` – Urja Satodiya Jan 11 '23 at 07:04
The OP asked for a solution in MySQL. – Bill Karwin Jan 11 '23 at 07:11

1 Answers1