Thanks Rudy that did the trick ----- Original Message ----- From: "rudy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 5:23 PM Subject: Re: [CFTALKTor] Count Distinct
> > 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) > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Mike" <[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)
