A
A
Artem2017-08-26 16:58:24
SQL
Artem, 2017-08-26 16:58:24

What would such a request look like?

For each car_id in the table, get the entry with the maximum date_stop. Returns only 1 row, but I need to unload for all car_id in the table
SELECT car_id, MAX(date_stop) FROM table

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2017-08-26
@proudmore

... group by car_id

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question