MIN, MAX and AVG
Along with summing and counting, you'll frequently need to find the minimum, maximum, and average of column values. Thankfully, T-SQL has functions you can use to make the task easier!
Bu egzersiz
Introduction to SQL Server
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Find the minimum number of affected customers
SELECT
___(affected_customers) AS ___
FROM
grid
-- Only retrieve rows where demand_loss_mw has a value
WHERE
___ ___ ___ NULL;