文件名称：比较操作符-SQL语言基础
文件大小：5.26MB
文件格式：PPT
更新时间：2024-05-15 13:24:49
SQL 基础
比较操作符 * 操作符 = > >= < <= <> 含义 等于 大于 大于或等于 小于 小于或等于 不等于 * Comparison Operators Comparison operators are used in conditions that compare one expression to another. They are used in the WHERE clause in the following format: Syntax … WHERE expr operator value Examples … WHERE hiredate='01-JAN-95' … WHERE sal>=1500 … WHERE ename='SMITH' Instructor Note Remind students that the expr cannot be an alias. Mention in brief about the date TO_DATE function, when the date is to be entered in a format other than the default format. This is required for practice 4.