oracle简单查询单词
| 单词 | 释义 |
|---|---|
| select | 查询 |
| from | 从... |
| where | 条件查询 |
| as | 别名 |
| not | 取反 |
| and | 和 |
| or | 或者 |
| between...and... | 范围取值,包含边界 |
| like | 模糊查询 |
| escape | 定义 转义字符 |
| order by | 排序 |
| asc | 正序 |
| desc | 倒序 |
| group by | 分组 |
| sum | 求和 |
| max | 最大值 |
| min | 最小值 |
| avg | 平均值 |
| count | 数量 |
| having | 条件查询 |
| case when...then else...end | 取值时,更改数据的值 |
