select avg(ALL UnitPrice) as 'All', avg(DISTINCT UnitPrice) as 'Distinct'
from products
select sum(ALL UnitPrice) as 'All', sum(DISTINCT UnitPrice) as 'Distinct'
from products
select min(ALL UnitPrice) as 'All', min(DISTINCT UnitPrice) as 'Distinct'
from products
select max(ALL UnitPrice) as 'All', max(DISTINCT UnitPrice) as 'Distinct'
from products
select count(ALL UnitPrice) as 'All', count(DISTINCT UnitPrice) as 'Distinct'
from products
select count_big(ALL UnitPrice) as 'All', count_big(DISTINCT UnitPrice) as 'Distinct'
from products
SELECT ProductName, Checksum(ProductName) as 'Checksum'
FROM Products
SELECT ProductName, BINARY_CHECKSUM(*) AS 'Binary checksum'
FROM Products
SELECT EmployeeID, CHECKSUM_AGG(EmployeeID) as 'Checksum aggregate'
FROM Orders
group by EmployeeID