数据库搜索命令

SELECT ename FROM emp;
SELECT ename,empno FROM emp;
SELECTFROM emp; – * 代表所有信息
SELECT empno,ename,sal12 FROM emp; – sal月薪，乘以12 为年薪
SELECT empno AS ‘编号’,ename AS ‘姓名’,sal AS ‘月薪’ FROM emp;
SELECT empno ‘编号’,ename ‘姓名’,sal ‘月薪’ FROM emp; – 为字段取别名，可以用as，别名用单引号或者双引号
SELECTFROM emp WHERE sal=‘5000’; – 查询月薪为5000的员工
SELECTFROM emp WHERE job=‘manager’; – 查询职位为经理的员工
SELECTFROM emp WHERE sal!=5000; – 查询月薪不等于5000的员工
SELECTFROM emp WHERE sal<>5000;
SELECTFROM emp WHERE sal>=1600 AND sal<=3000; – 查询月薪在1600到3000之间的员工
SELECTFROM emp WHERE comm=‘null’; – 查询津贴为0的员工
SELECTFROM emp WHERE comm IS NULL; – 查询津贴为空的员工
SELECTFROM emp WHERE comm IS NOT NULL; – 查询津贴不为空的员工
SELECTFROM emp WHERE job=‘manager’ AND sal>2500; – 查询岗位为经理并且月薪大于2500
SELECTFROM emp WHERE job=‘manager’ OR job=‘salesman’;