SQL Function Introduction

SQL FUNCTION
When we consider about the SQL FUNCTION we can identify three types of SQL functions such as SQL Aggregate Function, SQL String Function, and SQL Mathematic Function. By using those functions you can easily SQL query according to your requirements.

SQL Aggregate Function
Basically SQL Aggregate Function allows you to summarize the result of an expression for the group of rows and returns a single value for that group.

• SQL AVG Function
• SQL Count Function
• SQL MAX/ MIN Function
• SQL Sum Function

SQL String Function
Basically SQL String Function allows you to manipulate character data effectively.

• SQL ASCII Function
• SQL CHR or CHAR Function
• SQL CONCAT Function
• SQL LENGTH or LEN Function
• SQL Replace Function
• SQL Lower Function
• SQL Upper Function

SQL Mathematics Function
Basically SQL mathematics function provider idea about mathematic function. By using those function can do same mathematics calculation easily.

• SQL ABS Function
• SQL Cell (or Ceiling ) and Floor Function
• SQL Power Function
• SQL Rand Function
• SQL Round Function
• SQL SQRT Function
• SQL PI Function
• SQL Exp Function
• SQL Log Function
• SQL Trigonometric Function