FIT
100
More Complex Queries and SQL Functions
v
SQL’s Numeric Functions
o
COUNT
o
Examples:
;
SELECT COUNT(DISTINCT V_CODE)
FROM PRODUCT;
;
;
SELECT COUNT(DISTINCT V_CODE)
FROM PRODUCT
WHERE P_PRICE <= 10.00;