Find Most Recent X Records per Customer

[briangriffin]

New to MySQL - I could probably get this working in SQL Server, but I wouldn't be confident that the syntax would translate.

Simple task: multiple records per customer:

RecordID Customer
1 Joe
2 Joe
3 Joe
4 Joe
5 Sue
6 Sue
7 Sue
8 Sue

Need only the most recent three records per customer:

RecordID Customer
2 Joe
3 Joe
4 Joe
6 Sue
7 Sue
8 Sue

What is the most efficient way to do this in MySQL? Thanks in advance.

 

[briangriffin]

Finally found nice article that explains the workaround for this:

http://www.sqlines.com/mysql/how-to/get_top_n_each_group