Last Five Payments

[jorbroni]

Hi

I am trying to write a query that will give me the last 5 payments for each of our clients. Can anyone give me some ideas on how to write this query?

Thank you
Reggie

 

[ecobb]

Sure, write a select statement that pulls the info for the last 5 payments for each of your clients, that should give you what you want.

If you want any more details, you'll have to give us some more details. What do the database tables consist of? Are you tracking dates? What are some of the data columns?



Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[jorbroni]

Sorry About the lack of detail.

The table I am using consist of the Client code, Payment Date, Amount of each payment.

Thank you

 

[okiiyama]

select top 5 *
from table
order by PaymentDate desc

 

[ecobb]

Are you wanting just the top 5 records, or the top 5 records for each customer?



Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[jorbroni]

Actually, I am looking for the last 5 payments for each client.