Database - Define aggregate and scalar functions

Define aggregate and scalar functions.

- Aggregate Functions return a single value by operating against a group of values.
- Scalar functions operate against a single value.

Define aggregate and scalar functions.

The aggregate functions always return a single value, which is the result of a column values.
EX: SUM(),COUNT(),AVERAGE(),MIN(),MAX()

A scalar functions returns a single value based on the value given as argument to the function.
Ex: UCASE(), LCASE(),LEN(),NOW()

Database - What are the restrictions applicable while creating views?
Views can be created referencing tables and views only in the current database...
Database - What is "correlated subqueries"?
A correlated sub query is a type of sub query. Unlike sub query, a correlated sub query is dependent upon the outer query....
Database - What is Data Warehousing?
Data Warehousing is a process of storing and accessing data from central location for some strategic decision...
Post your comment