Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
3 best buyers per year
Hello, can anybody help me with this? I have a 2500 records in one table where i have registered the last 5 years sales. How can I >>sum all the sales of a customer in a given year >>get the top 3 buyers in a given year >>for the whole period (5 years) >>in only one sql stament, if possible... -
3 top buyers per year
Hello, can anybody help me with this? I have a 2500 records in one table where i have registered the last 5 years sales. How can I >>sum all the sales of a customer in a given year >>get the top 3 buyers in a given year >>for the whole period (5 years) >>in only one sql stament, if possible...
