RE: [CFTALKTor] Count Distinct

[Mike Lau]

try this:   SELECT Count(*) FROM (SELECT DISTINCT [SIN] FROM [YourTableName]) yourtable   ============================= Mike Lau Web Developer [EMAIL PROTECTED] www.userinmind.com ============================= -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Sent: Thursday, April 11, 2002 5:06 PM To: [EMAIL PROTECTED] Subject: [CFTALKTor] Count Distinct Hi All,   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?   Thanks   Mike