Alphabetical list of functions
324
returns the value 0.86781.
♦
SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
"ACOS function" on page 313
"COT function" on page 324
"SIN function" on page 365
"TAN function" on page 370
COT function [Numeric]
Returns the cotangent of a number.
COT (
numeric-expression
)
numeric-expression The angle, in radians.
The following statement returns the value 1.74653.
SELECT COT( 0.52 )
♦ SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
"COS function" on page 323
"SIN function" on page 365
"TAN function" on page 370
COUNT function [Aggregate]
Counts the number of rows in a group depending on the specified
parameters.
COUNT (
*
|
expression
|
DISTINCT
column-name
)
* Returns the number of rows in each group.
expression Returns the number of rows in each group where the
expression is not the null value.
DISTINCT column-name Returns the number of different values in the
column with name column-name. Rows where the value is the NULL value
are not included in the count.
The following statement returns each unique city, and the number of rows
with that city value:
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
Example
To Next Page
Loading...