StructuredQueryLanguage（结构化查询语言）.ppt

Structured Query Language (結構化查詢語言) Lesson Review What is S Q L? Lesson Review How to involve SQL in FoxPro Basic structure of an SQL query General Structure Before using SQL, open the student file: USE student General Structure General Structure General Structure General Structure General Structure General Structure Comparison Comparison Comparison Comparison Comparison Comparison Grouping Grouping Grouping Grouping Grouping Grouping Grouping Grouping Display Order Display Order Display Order Display Order Display Order Display Order Output Output Output  Union, Intersection and Differ