SQL Oracle PHP Java JSP JDBC MORE
Need a Website Or Web Application Or Any Help.Contact Us: +91 9437911966 (Whatsapp) Note: Paid Service

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