Limit query result per unique columns combination

I would like to modify this query to limit result to have max 2 rows (latest) per group:

select
	distinct clusterName,
	aksNamespace,
	acrName,
	acrImageName,
	acrImageVersion,
	date
from
	(
	select
		clusterName,
		aksNamespace,
		acrName,
		acrImageName,
		acrImageVersion,
		date
	from
		aks_images
	order by
		acrImageName,
		date desc
) as t
where
	acrName = "storage"
order by
	clusterName,
	acrImageName,
	date desc

Current result:

Expected result:

Mysql version: 8.0.31

I'd be grateful for any advice or solutions.

On MySQL 8+, we can use ROW_NUMBER():

<!-- language: sql -->

WITH cte AS (
    SELECT *, ROW_NUMBER() OVER (PARTITION BY clusterName, acrImageName
                                 ORDER BY date DESC) rn
    FROM aks_images
    WHERE acrName = 'storage'
)

SELECT
    clusterName,
    aksNamespace,
    acrName,
    acrImageName,
    acrImageVersion,
    date
FROM cte
WHERE rn <= 2
ORDER BY
    clusterName,
    acrImageName,
    date DESC;