SELECT t1.navn_upc, t.kunde_id, t.abm_lopenr, MAX(t.abv_lopenr) l
FROM CUSTOMER.ab_versjon t INNER JOIN CUSTOMER.kunde t1 ON t.kunde_id = t1.kunde_id
WHERE t.kunde_id >= 215380 AND t.kunde_id < 215390
GROUP BY t1.navn_upc, t.kunde_id, t.abm_lopenr
ORDER BY t.kunde_id, t.abm_lopenr DESC