I have a table with prices per article. But there can be more prices for one article. So I want to get a result with only the lines of the last price (based on the last date). I used the query below but I still get more lines per article.
select artref, MAX(date) as ldate,price from prices
group by artref, price
Can someone help me out of this please.