【文件属性】:
文件名称:比较操作符-SQL语言基础
文件大小:5.26MB
文件格式:PPT
更新时间:2021-04-25 19:38:09
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.