SELECT SQL. (ORDER BY). (GROUP BY, GROUP BY HAVING). |
ORDER BY
SELECT Company, OrderNumber
FROM Orders
ORDER BY Company;
ORDER BY 2 DESC –
OrderNumber SELECT Company, OrderNumber FROM Orders
- GROUP BY
SELECT column, SUM(column) FROM table GROUP BY column
SELECT Company,SUM(Amount) FROM Sales GROUP BY Company;
SELECT column,SUM(column) FROM table GROUP BY column HAVING SUM(column) condition value
SELECT Company,SUM(Amount) FROM Sales
GROUP BY Company HAVING SUM(Amount)>10000;
FROM Store_Information
ORDER BY Company DESC;
(DESC )
SELECT store_name, Sales, Date
3) . IBM ESS Shark. RAID-. RAID. (IBM Virtual Tape Library) CD Library IBM .
. , . . .
. , . « » (FCFS – first-come-first-served) « – » (SSTF – shortest-seek-time-first)
50- XX . IBM (). 1954 . (1906-1998).
, , . . , , /, . RAID - Redundant Array of Independent (Inexpensive) Disks ( ( ) ).RAID 0 (Stripe). , . , . , . . - , .RAID 1 (Mirror). , , . . . .Matrix RAID. RAID-0, RAID-1 RAID 3. RAID 2, ECC , , ECC , . - , .RAID 4. RAID 3, Stripe- . - . , RAID 3, . RAID-3 RAID-2 : . : , , . , .RAID-4 RAID-3, , , . , "" . - , . .RAID 5 - . () . . , , , RAID 1. . , , . RAID 6: RAID-5, . , . , 5, , , . . . : n , , , n-2. . : , , . , . RAID-7 - Storage Computer Corporation. : n-1 , . , : , . . (- ). , , , RAID 1.
" ":
1 - . .
2 -
...
11 - UPDATE SQL. .
12 - ( -; ; ;
13 - SELECT SQL. (ORDER BY). (GROUP BY, GROUP BY HAVING).
14 - , (dBase, Clipper, FoxPro, Paradox). .
15 - . GRANT REVOKE. .
...
43 - .
44 - - . .
45 - .
| : |
