SQL语句应用1答题.docx

目 录  TOC \o 1-3 \h \z \u  HYPERLINK \l _Toc112671541 第1章 SQL语句基础  PAGEREF _Toc112671541 \h 7  HYPERLINK \l _Toc112671542 1.1 SQL语句概述  PAGEREF _Toc112671542 \h 7  HYPERLINK \l _Toc112671543 1.1.1 SQL语句的作用  PAGEREF _Toc112671543 \h 7  HYPERLINK \l _Toc112671544 1.1.2 SQL语句的适用范围  PAGEREF _Toc112671544 \h 7  HYPERLINK \l _Toc112671545 1.2 SQL语句的分类  PAGEREF _Toc112671545 \h 7  HYPERLINK \l _Toc112671546 1.2.1 DML语句  PAGEREF _Toc112671546 \h 7  HYPERLINK \l _Toc112671547 1.2.2 DDL语句  PAGEREF _Toc112671547 \h 8  HYPERLINK \l _Toc112671548 1.2.3 DCL语句  PAGEREF _Toc112671548 \h 8  HYPERLINK \l _Toc112671549 第2章 SQL语句基础  PAGEREF _Toc112671549 \h 9  HYPERLINK \l _Toc112671550 2.1 字符函数  PAGEREF _Toc112671550 \h 9  HYPERLINK \l _Toc112671551 2.1.1 CHR  PAGEREF _Toc112671551 \h 9  HYPERLINK \l _Toc112671552 2.1.2 CONCAT  PAGEREF _Toc112671552 \h 9  HYPERLINK \l _Toc112671553 2.1.3 INITCAP  PAGEREF _Toc112671553 \h 10  HYPERLINK \l _Toc112671554 2.1.4 LOWER和UPPER  PAGEREF _Toc112671554 \h 10  HYPERLINK \l _Toc112671555 2.1.5 LPAD与RPAD  PAGEREF _Toc112671555 \h 11  HYPERLINK \l _Toc112671556 2.1.6 LTRIM与RTRIM  PAGEREF _Toc112671556 \h 11  HYPERLINK \l _Toc112671557 2.1.7 REPLACE  PAGEREF _Toc112671557 \h 12  HYPERLINK \l _Toc112671558 2.1.8 SUBSTR  PAGEREF _Toc112671558 \h 12  HYPERLINK \l _Toc112671559 2.1.9 TRANSLATE  PAGEREF _Toc112671559 \h 13  HYPERLINK \l _Toc112671560 2.1.10 INSTR  PAGEREF _Toc112671560 \h 13  HYPERLINK \l _Toc112671561 2.1.11 LENGTH  PAGEREF _Toc112671561 \h 14  HYPERLINK \l _Toc112671562 2.2 数字函数  PAGEREF _Toc112671562 \h 14  HYPERLINK \l _Toc112671563 2.2.1 ABS  PAGEREF _Toc112671563 \h 14  HYPERLINK \l _Toc112671564 2.2.2 CEIL和FLOOR  PAGEREF _Toc112671564 \h 15  HYPERLINK \l _Toc112671565 2.2.3 MOD  PAGEREF _Toc112671565 \h 15  HYPERLINK \