How to select two fresh values?

Question

MySQL

There is a table, I want currency_second 1 and 3 to take a freshly added row?

Or how to combine two queries into one, see the example below.

SELECT * FROM exchange WHERE currency_secound = 1 ORDER BY id DESC LIMIT 1

SELECT * FROM exchange WHERE currency_secound = 3 ORDER BY id DESC LIMIT 1

Answer 1

for 5.7 there are no window functions, which means an old tried-and-true crutch, provided that id is a surrogate auto_increment key

SELECT *
FROM `exchange` e 
WHERE e.`currency_secound` IN (1,3) AND e.`id` = (
    SELECT MAX(e2.`id`) FROM `exchange` e2 WHERE e2.`currency_secound` = e.`currency_secound` 
)

Answer 2

UNION ALL