91-9990449935 0120-4256464 |
MySQL min() functionThe MySQL min() function is used to return the minimum value from the table. Syntax: Parameter explanationaggregate_expression: It specifies the column or expression, from which the minimum value will be returned. table_name: It specifies the tables, from where you want to retrieve records. There must be at least one table listed in the FROM clause. WHERE conditions: It is optional. It specifies the conditions that must be fulfilled for the records to be selected. MySQL min() function exampleConsider a table named "employees", having the following data. Execute the following query: Output:
Next TopicMySQL max()
|