August 2014

Avg():- This function is used to get the average value of a numeric column Syntax:-       SELECT AVG(column_name) FROM table_name

UPPER():- This function is used to convert the value of a column to upper case.  Syntax:    SELECT UPPER(string) OR

LEN():- This function is used to get the length of the given string value.   Syntax:-     Select len (stringvalue)

LOWER():- This function is used to convert the value of a column to lower case  Syntax:-  Select LOWER (string)  

LTRIM ():- This function is used to get the string after the removal of leading blank spaces. Syntax:- LTRIM (

Substring():- This function is used to return the specified number (third argument “len”) of characters from a given string(first argument)

Max():- This function gives the maximum value of the selected column Syntax:- Select Max (col1) from table_name In this article,

RTRIM():-This function is used to get the string after the removal of all trailing blanks. Syntax:- RTRIM ( character_expression )

Sum():- This function is used to get the sum of values of the specified numeric column.  Syntax:-  Select Sum (column_name)

Round():-This function is used to round a numeric field to the number of decimals specified. Syntax:-     ROUND ( numeric_expression

Like:- This operator is used in a WHERE clause to search for a specific pattern in the values of the