Syntax
To specify a group function, you write the name of the function followed by an argument in parentheses. The argument can be a column name, an expression, or a constant. 
COUNT Function
The COUNT function returns the number of non-null values in a column. If you count the values of a primary key column, you will find the number of rows in a table because a primary key column cannot contain nulls.
Group Functions: Part 2
Sunday, January 31, 2010
by
Abdul Majid Niazi
·
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2010
(53)
-
▼
January
(52)
- Creating Groups: Part 1
- Using the Grouping Functions
- Group Functions: Part 2
- Group Functions: Part 1
- Group Functions: Part 1
- Working with Groups of Data
- Using the NVL Function
- Using the NVL Function
- Formatting Dates
- Formatting Dates
- Using Date Functions
- Date Functions: Part 2
- Date Functions: Part 1
- Using Numeric Functions
- Number Functions
- Using Character Functions
- Character Functions: Part 2
- Character Functions: Part 1
- Using Functions to Customize Reports
- Joining Multiple Tables
- Joining Multiple Tables
- Applying Additional Conditions to a Join
- Applying Additional Conditions to a Join
- Joining Tables and Identifying Columns
- Joining Tables and Identifying Columns
- Simple Joins
- Simple Joins
- Joining Tables
- Retrieving Rows
- Retrieving Rows
- Retrieving Columns
- Retrieving Columns
- Writing a Basic Query
- Writing a Basic Query
- Building Queries
- Building Queries: Part 2
- Building Queries
- Accessing Data
- Removing a Copy of a Table
- Removing Tables
- Implementing Business Rules
- Creating Constraints
- Identifying Constraints
- Managing Constraints
- Adding a New Column
- Modifying Tables
- Creating a Copy of a Table
- Creating Tables Using SQL
- Creating Tables by Using the Object Browser
- Creating Tables
- Working with Database Objects
- Relational data base
-
▼
January
(52)
0 comments:
Post a Comment