In Oracle MIN() function used to get the smallest value of the selected column.
SELECT MIN(column_name)
FROM table_name
WHERE condition;
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 |
SELECT MIN(Run) AS LowestRun
FROM cricket_score;