SQL Oracle Java JSP JDBC PHP MORE

Oracle MIN Function with Example

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

Oracle MIN() Syntax

SELECT MIN(column_name)
FROM table_name
WHERE condition;

Oracle 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

Oracle Query

SELECT MIN(Run) AS LowestRun
FROM cricket_score;

Output

LowestRun

50