SQL Scalar functions

Diffending on input value this function will returns the single value.

•UCASE() - Converts a field to upper case
•LCASE() - Converts a field to lower case
•MID() - Extract characters from a text field
•LEN() - Returns the length of a text field
•ROUND() - Rounds a numeric field to the number of decimals specified
•NOW() - Returns the current system date and time
•FORMAT() - Formats how a field is to be displayed

SQL Aggregate Functions

Diffending on value in column this function will return a single value.


•SUM() - Returns the sum
•COUNT() - Returns the number of rows
•FIRST() - Returns the first value
•LAST() - Returns the last value
•MAX() - Returns the largest value
•AVG() - Returns the average value

See Before and after disaster pic of Japan

Move the slider to compare satellite images from before and after the disaster.



http://www.nytimes.com/interactive/2011/03/13/world/asia/satellite-photos-japan-before-and-after-tsunami.html?hp