SQL Basic
SQL HOME
SQL Intro
SQL Select
SQL Where
SQL Insert
SQL Update
SQL Delete

SQL Demo
SQL Try It

SQL Advanced
SQL Order By
SQL and & or
SQL In
SQL Between
SQL Aliases
SQL Join
SQL Union
SQL Create
SQL Drop
SQL Alter
SQL Functions
SQL Group By
SQL Select Into
SQL Create View
SQL Server

SQL Quick Ref
SQL Summary

SQL Quiz
SQL Quiz

Selected Reading
Web Statistics
Web Glossary
Web Hosting
Web Quality

W3Schools Tutorials
W3Schools Forum

Helping W3Schools

SQL COUNT DISTINCT Function

Note: The following example works with ORACLE and Microsoft SQL server but not with Microsoft Access.

The keyword DISTINCT and COUNT can be used together to count the number of distinct results.

Syntax

SELECT COUNT(DISTINCT column(s)) FROM table

Example

With this "Orders" Table:

Company	OrderNumber
Sega	3412
W3Schools	2312
Trio	4678
W3Schools	6798

Example

SELECT COUNT(Company) FROM Orders

Result:

Example

SELECT COUNT(DISTINCT Company) FROM Orders

Result:

The Ektron Intranet lets you do everything you need to do on your corporate intranet and everything you want to do... all with just one application.

What can you do with the Ektron Intranet?

	Navigate through content, documents, assets, colleagues and workgroups quickly and intuitively with enterprise search
	Communicate with friends and colleagues with forums, message boards and corporate blogging using the new Social Networking Platform
	Utilize the extensive out-of-the box features or customize your site through Ektron CMS400.NET's open architecture
	Promote collaboration in your organization through project workspaces where others can efficiently find information and work together
	Author/edit content, manage navigation, menus, audit trails, workflow and approvals with the best in breed Content Management

See why there are 20,000+ Ektron integrations worldwide.

TAKE THE VIDEO TOUR

or download a FREE TRIAL today.

Jump to: Top of Page or HOME or Printer friendly page

W3Schools provides material for training only. We do not warrant the correctness of its contents. The risk from using it lies entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

W3Schools was converted to XHTML in December 1999