结构化查询语言SQLѧϰ.pptVIP

Guoxin Lucent Proprietary SQL学习 1. Writing Basic SQL SELECT Statements Basic SELECT Statement SELECT identifies what columns FROM identifies which table Selecting All Columns Selecting Specific Columns Arithmetic Expressions Create expressions with number and date data by using arithmetic operators. Operator Precedence Using Column Aliases Using the Concatenation Operator Using Literal Character Strings Eliminating Duplicate Rows 2. Restricting and Sorting Data Limiting the Rows Selected Restrict the rows returned by using the WHERE clause. The WHERE clause follows the FROM clause. Us