Thanks for your quick response, > select count(DISTINCT Name) nameCount from TableA
This is not working :(. I am getting the same error. -- Bharath On 2/27/08 12:38 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Try > select count(DISTINCT Name) nameCount from TableA > > Shibu Narayanan > Consultant, PrimeSourcing Division, Investment Banking Group > Tel.Office: 91-80-2208-6270 or 91-80-6659-6270 > e-mail: [EMAIL PROTECTED] > The answer is 42. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bharath Booshan L > Sent: Wednesday, February 27, 2008 12:35 PM > To: Discussion of SQLite Database > Subject: [sqlite] Query to Find number of distinct records > > Hello All, > > This might be simple question, but am not getting the SQL query right > for > my problem. > > > For eg, consider following table > > NonUniqueNo Name > ----------------- > 23 A > 23 B > 24 C > 25 A > 23 E > > > How can I find the number of people for which an entry has been recorded > in > my table? > > The answer I am expecting is 4 ( i.e. A,B,C,E) > > Using query "select count(DISTINCT Name) from TableA" results in an > error. > > Could anyone please post a SQL query for my problem? > > Thanks in advance, > > Bharath > > > > ----------------------------------------------- > Robosoft Technologies - Come home to Technology > > Disclaimer: This email may contain confidential material. If you were > not an intended recipient, please notify the sender and delete all > copies. Emails to and from our network may be logged and monitored. This > email and its attachments are scanned for virus by our scanners and are > believed to be safe. However, no warranty is given that this email is > free of malicious content or virus. > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > DISCLAIMER: > This message contains privileged and confidential information and is intended > only for an individual named. If you are not the intended recipient, you > should not disseminate, distribute, store, print, copy or deliver this > message. Please notify the sender immediately by e-mail if you have received > this e-mail by mistake and delete this e-mail from your system. E-mail > transmission cannot be guaranteed to be secure or error-free as information > could be intercepted, corrupted, lost, destroyed, arrive late or incomplete or > contain viruses. The sender, therefore, does not accept liability for any > errors or omissions in the contents of this message which arise as a result of > e-mail transmission. If verification is required, please request a hard-copy > version. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ----------------------------------------------- Robosoft Technologies - Come home to Technology Disclaimer: This email may contain confidential material. If you were not an intended recipient, please notify the sender and delete all copies. Emails to and from our network may be logged and monitored. This email and its attachments are scanned for virus by our scanners and are believed to be safe. However, no warranty is given that this email is free of malicious content or virus. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
