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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by digits125
-
Ranking Data
I have a select statement which is intended to output rows ranked by totalsales for a given area which goes like this: SELECT A.name, A.district, A.month, A.year, A.totalsales, (SELECT COUNT(DISTINCT totalsales) FROM mreport B WHERE B.year = 2003 AND B.month = 1...
