, . , . , ( ). , .
, . , Boutique Fudge, , , . , , (. . " " 7), , , , .
, . , ( ) .
SQL
, , SQL (Structured Query Language, ). SQL , , .
, : "--" ( ) "" ( Microsoft SQL Sever). , "".
( ), Access SQL. , Access . , .
SQL, . . .
■ , SQL, . , , . , SQL , .
■ SQL. , , , Access.
|
|
■ . Access Oracle. , , , , , , . SQL, .
■ . SQL Access.
■ SQL, .
SQL SQL (SQL View). . 6.13 , .
. 6.13. SQL TopProducts, , 50 . , ,
, SQL , . , ( ), :
1. SELECT Products.ID, Products.ProductName, Products.Price
2. FROM Products
3. WHERE (((Products.Price)>50))
4. ORDER BY Products.Price;
.
■ 1 SELECT, , , ( , ).
SELECT , . . , , .
2 from, (), . Products. .
, .
■ 3 WHERE, . 50 . , , and.
Access . SQL WHERE (((Products. Price) >50)) WHERE Products. Price>50. Access , .
■ 4 ORDER BY, .
Price ().
|
|
, desc .
, .
(;). Access , SQL.
, , , , SELECT, FROM, WHERE ORDER BY.
Access . SQL, ,
( , Access ).
SQL , , ( ):
SELECT Products.ID, Products.ProductName, Products.Price, Products.Description
FROM Products
WHERE (((Products.Price)>100))
ORDER BY Products.Price, Products.ProductName;
, , , .