Re: Need help counting player with lowest score for each week.

2006-01-09 Thread Thomas 'Skip' Hollowell
BY DATE, place ASC ) as A GROUP BY A.date) AS B GROUP BY B.playerid ORDER BY Bubbles DESC; Thomas 'Skip' Hollowell wrote: How do I simply find out who the bubble is now in my db now that we track more than 1 $0 person. I need just the person with $0 in the amount column with the lowest Place

Need help counting player with lowest score for each week.

2006-01-06 Thread Thomas 'Skip' Hollowell
How do I simply find out who the bubble is now in my db now that we track more than 1 $0 person. I need just the person with $0 in the amount column with the lowest Place for each date. I can iterate through it all if needed in PHP, but I am always looking to learn more SQL tricks. I am