> I was wondering if any one can help me with an SQL statement on Sybase. > I have a database with many account numbers but and SIN numbers. I am > trying to count the amount of unique SIN numbers but I can't get the syntax > right can anyone help with this?
hi mike yes what did you mean "many account numbers but and SIN numbers"? but and? try select count (distinct sinno) from yourtable if that doesn't work, please show table layout rudy - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "rudy" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
