FIT
100
Queries
v
Partial Listing of Table Contents
o
SELECT <column(s)>
FROM <table name>
WHERE <conditions>;
o
Examples:
;
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344;
Selected PRODUCT Table Attributes for
the VENDOR CODE 21344