Ask a question
          

Aggregate and scalar functions

<<Previous   Next>>

Database - aggregate and scalar functions - April 12, 2009, 14:50 pm by Nishant Kumar

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. 

Database - aggregate and scalar functions - Jan 08, 2010, 15:55 pm by Vidya Sagar

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()

<<Previous   Next>>
 



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
 
Home | Login | About us | Sitemap | Contact us