DMSQL

简介

DMSQL 基于 sql92，部分基于 sql99 的。

Sql 语句的分类

DQL:数据查询语句 select …from …where 组成的查询块
DDL:数据定义语句 create table create view
DML:数据操作语句：insert update delete
DCL:数据控制语句：grant revoke commit lock unlock

简单查询

select employee_name,salary, salary+1000 from dmhr.employee; select employee_name,salary,salary+1000 as "TOL" from dmhr.employee; select distinct department_id from dmhr.employee;
select department_id,employee_name||' 工 资 是 ： '||salary from dmhr.employee;

# 使用 order by 子句排序
# ASC:升序 Desc：降序
select employee_id,employee_name, salary from dmhr.employee where salary BETWEEN 25000 and 30000; 等价转换 select employee_id,employee_name, salary from dmhr.employee where salary >=25000 and salary <=30000; select employee_id,employee_name