I have a table that consist of a custom ID, year and amount column. Customers can have one row per year in that table with an amount. I want to do an SQL statement that retrieves the latest year (i.e 2015) record for each Customers.
I'm not interested in records before year 2015!
Can somebody explain for me how to do an SQL statement that retrieves my information.