RE: How to count the number of records of sql statement with DISTINCT?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Brian (anonymous_at_discussions.microsoft.com)
Date: 04/20/04 

Date: Tue, 20 Apr 2004 12:46:09 -0700

It may depend on your DBMS. Oracle and SQL server will allow just what you are doing (Select Count(distinct X) from TBLX....). Im not sure if this works on all/most databases though.

Relevant Pages

  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: importing/translating from DBMS en masse to SQL
    ... DBMS and export it into a SQL Server db nightly ... DBMS databases, but searching for and collecting even moderate amounts ... I am not familiar with the Oracle CODASYL database but you should be ...
    (comp.databases.oracle.misc)
  • Re: Reference integrity between two databases
    ... I have a feeling that a better comparison to schema in Oracle would be schema in SQL Server. ... MSSQL databases like a synonym to Oracle schemas - and evidently the analogy isn't completely correct. ... But every application needs to work with customers somehow. ...
    (microsoft.public.sqlserver.programming)
  • Re: database dilemma
    ... > Dot net uses SQL Server and Oracle (check the help for the supported ... > versions) most efficiently as it has native drivers for these databases ... > Other databases use ODBC which work but with an overhead. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: database dilemma
    ... Dot net uses SQL Server and Oracle (check the help for the supported ... Other databases use ODBC which work but with an overhead. ... boss last week dropped vb.net on my desk and wants to create a web app and a ...
    (microsoft.public.dotnet.languages.vb)