SQL Oracle PHP Java JSP JDBC MORE

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