SQL MIN The SQL MIN function returns the minimum value in a select query. MIN syntax SELECT MIN(table_column) FROM table_name; MIN example Coder books table ID Title Price Description 1 Learn SQL 20 Learn SQL language 2 Learn MySQL 22 Learn...
SQL MAX The SQL MAX function returns the maximum value in a select query. MAX syntax SELECT MAX(table_column) FROM table_name; MAX example Coder books table ID Title Price Description 1 Learn SQL 20 Learn SQL language 2 Learn MySQL 22 Learn...
SQL SUM The SQL SUM function returns the sum value of all rows in a select query. SUM syntax SELECT SUM(table_column) FROM table_name; SUM example Coder books table ID Title Price Description 1 Learn SQL 20 Learn SQL language 2 Learn...
SQL Count The SQL COUNT function returns the number of the rows in a select query. COUNT syntax SELECT COUNT(*) FROM table_name; SELECT COUNT(column_name) FROM table_name; COUNT example Coder books table ID Title Price Description 1 Learn SQL 20 Learn SQL...
SQL AVG The SQL AVG function returns the average in a select query. AVG syntax SELECT AVG(table_column) FROM table_name; AVG example Coder books table ID Title Price Description 1 Learn SQL 20 Learn SQL language 2 Learn MySQL 22 Learn MySQL...