Difference between revisions of "COUNT()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=COUNT()=
 
 
 
==Class==
 
SQL Applications
 
 
 
 
==Purpose==
 
==Purpose==
 
Returns the number of rows in a SELECT statement query
 
Returns the number of rows in a SELECT statement query
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
[[SQL Aggregate Functions|AGGREGATES]], [[AVG()]], [[SQL MAX()|SQL MAX()]], [[SQL MIN()|MIN()]], [[SQL SELECT|SELECT]], [[SUM()]]
+
[[SQL Aggregate Functions|AGGREGATES]], [[AVG()]], [[SQL MAX()|MAX()]], [[SQL MIN()|MIN()]], [[SQL SELECT|SELECT]], [[SUM()]]
  
  
Line 25: Line 18:
 
<code lang="recital">
 
<code lang="recital">
 
// Get a count of all rows in the accounts table.
 
// Get a count of all rows in the accounts table.
SELECT COUNT(*) Total FROM accounts;
+
SELECT COUNT(*) Total FROM accounts
  
 
// Get a count of jobs
 
// Get a count of jobs
SELECT COUNT(jobs) Jobs FROM employee;
+
SELECT COUNT(jobs) Jobs FROM employee
  
 
// Get a count of distinct rows for jobs
 
// Get a count of distinct rows for jobs
SELECT COUNT(DISTINCT jobs) Jobs FROM employee;
+
SELECT COUNT(DISTINCT jobs) Jobs FROM employee
 
</code>
 
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 17:16, 22 December 2009

Purpose

Returns the number of rows in a SELECT statement query


Syntax

COUNT(* | [DISTINCT] <expr>)


See Also

AGGREGATES, AVG(), MAX(), MIN(), SELECT, SUM()


Description

Returns the number of rows in the query. If you specify DISTINCT, then only the rows which are unique in <expr> are counted. Specifying <expr> on its own returns the number of rows from the query for which <expr> is not NULL. If you specify the asterisk (*), then all rows are counted.


Example

// Get a count of all rows in the accounts table.
SELECT COUNT(*) Total FROM accounts
 
// Get a count of jobs
SELECT COUNT(jobs) Jobs FROM employee
 
// Get a count of distinct rows for jobs
SELECT COUNT(DISTINCT jobs) Jobs FROM employee


Products

Recital Server, Recital