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