Thread: Aggregate and scalar function in SQL.

Hi. I am new in SQL. I want to know about which are the Aggregate and scalar function in SQL. If you are having any information then reply me. It is highly appreciated. Thank you.

SQL Aggregate Functions: SQL aggregate functions return a single value, calculated from values in a column.

• AVG() - Returns the average value

• COUNT() - Returns the number of rows

• FIRST() - Returns the first value

• LAST() - Returns the last value

• MAX() - Returns the largest value

• MIN() - Returns the smallest value

• SUM() - Returns the sum

SQL Scalar functions: SQL scalar functions return a single value, based on the input 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