SQL AVG()

SQL AVG()

Learn what is AVG() function in SQL server and how to use AVG() in sql query.
SQL COUNT()

SQL COUNT()

Learn what is COUNT() function in SQL server and how to use COUNT() in sql query.
SQL LEN()

SQL LEN()

Learn what is LEN() function in SQL server and how to use LEN() in sql query.
SQL LCASE()

SQL LCASE()

Learn what is LCASE() function in SQL server and how to use LCASE() in sql query.
SQL UCASE()

SQL UCASE()

Learn what is UpperCase function in SQL server and how to use UCASE() in sql query.
SQL MAX()

SQL MAX()

Learn what is MAX() function in SQL server and how to use MAX() in sql query.
SQL MIN()

SQL MIN()

The SQL MIN() function is used to return the lowest value from a selected column.
SQL SUBSTRING()

SQL SUBSTRING()

SQL SUBSTRING() function is used to return part of text or characters of a text.
SQL NOW()

SQL NOW()

SQL NOW() function is used to return current database server date and time.
SQL SUM()

SQL SUM()

SQL SUM() function is used to return total sum of numeric values.