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