MIN Example:
| CONTRACT_ID | AMOUNT |
|---|---|
| 1 | 400 |
| 2 | 500 |
| 3 | 700 |
SELECT MIN(c.amount) AS MinAmount
FROM contracts c
WHERE c.amount > 300;
| MinAmount |
|---|
| 400 |
See also: T-SQL Functions -> Avg -> Count -> Max -> Sum
| CONTRACT_ID | AMOUNT |
|---|---|
| 1 | 400 |
| 2 | 500 |
| 3 | 700 |
SELECT MIN(c.amount) AS MinAmount
FROM contracts c
WHERE c.amount > 300;
| MinAmount |
|---|
| 400 |
See also: T-SQL Functions -> Avg -> Count -> Max -> Sum