WWW.DISSERS.RU


...
    !

., ., . SQL , . ,

, , , , .

SQL .

, .

5 7 9 1. SQL 15 15 : 16 17 1 2. " " -- -- -- bookbiz 3. SQL CREATE INDEX , SQL-92 , SELECT INSERT UPDATE SET WHERE : DELETE 4. SELECT : : SELECT * : , : : WHERE (BETWEEN NOT BETWEEN) (IN NOT IN) : LIKE 5. SELECT : ORDER BY ORDER BY ? : DISTINCT ALL DISTINCT ! 6. GROUP BY GROUP BY HAVING HAVING HAVING WHERE 7. , , : UNION UNION 8. ? ! ! ? ? , , IN , NOT IN IN , ANY ALL , GROUP BY HAVING , NOT EXISTS EXISTS UPDATE, DELETE INSERT 9. () - ? Check Option ANSI 10. , , GRANT REVOKE , SQL 11. SQL , GROUP BY 1 12. , , GROUP BY WHERE HAVING ? HAVING DISTINCT DISTINCT DISTINCT DISTINCT DISTINCT? "" . SQL, . SQL . . bookbiz CREATE INSERT BOOKBIZ . , , 100 , 23 , , 17 , 114 , , 16 , , , 16 , 20;

183 , , 208 , , 22 , , 90 , , 23 , , 103 , , 72 , , 146 , , 28 , 200 , , 37 , , 17 , 67 , , , 37 , 56 , , , 143 , 27 , , 27 , , 26 , , 36 , , , 17 , , 16 , , 24 , , 19 , , 17 , , 17 , , 213 , , 16 , , , 16 , 159 , , 42 , , 16 , , 16 , , 100 , , 23 , , 58 , 24;

, 25 , , 20 , 183 , , 83 , , 136 , , , 197 , 16 , , 23 , 209 , , 16 , 58 ,




2011 www.dissers.ru -

, .
, , , , 1-2 .