摘要: ObjectivesAfter completing this lesson,you should be able to do the following:Limit the rows that are retrieved by a query.Sort the rows that are retrieved by a query.Use ampersand substitution to restrict and sort output at run time.Lesson AgendaLimiting rows with:-The WHERE clause-The comparison c 阅读全文
posted @ 2013-04-14 18:22 ArcerZhang 阅读(834) 评论(0) 推荐(0) 编辑
摘要: ObjectiveAfter completing this lesson,you should be able to do the following:List the capabilities of SQL statements.Execute a basic SELECT statementLesson AgendaBasic SELECT statementArithmetic expressions and NULL values in the SELECT statementColumn aliasesUse of concatenation operator,literal ch 阅读全文
posted @ 2013-04-14 13:44 ArcerZhang 阅读(325) 评论(0) 推荐(0) 编辑