FIT
100
More Complex Queries and SQL Functions
o
MAX
and
MIN
o
Examples:
;
SELECT MAX(P_PRICE)
FROM PRODUCT;
;
;
SELECT MIN(P_PRICE)
FROM PRODUCT;
;
;
SELECT P_CODE, P_DESCRIPT, P_PRICE
FROM PRODUCT
WHERE P_PRICE =
(SELECT MAX(P_PRICE) FROM PRODUCT);