briangriffin
Programmer
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.
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.