Menu

SQL MIN Function with Example


In SQL MIN() function used to get the smallest value of the selected column.

SQL MIN() Syntax

SELECT MIN(column_name)
FROM table_name
WHERE condition;

SQL MIN() Example

In this example we show you lowest run of Virat.

Table Name :cricket_score

MatchNo Name Run Wicket
1 Virat 78 1
2 Virat 82 2
3 Viart 50 0

SQL Query

SELECT MIN(Run) AS LowestRun
FROM cricket_score;

Output

LowestRun

50








Connection failed: SQLSTATE[28000] [1045] Access denied for user 'studentdb'@'localhost' (using password: YES)

Subscribe