I have a table where I have uuid
as PK, command_name
string, count_successful
integer and command_start
date.
I can grab all records by:
select
uuid,
command_name,
count_successful,
command_start
from
sync_logs
order by
command_start desc;
But above query will give me for example 78
records where command_name
equals to foo
and 45
records with command_name
equals to bar
.
How can I get max of 10
recent records per command_name
?