一.基本SQL-SELECT语句
-
查看表信息
select * from emp;
-
查看表中的列
desc emp;
desc 是SQL Plus关键字,不是SQL关键字
-
查看表中的某列
select employee_id from emp;
-
运算符
select 2*2 from dual; # 没有表是可用dual伪表代替 select last_name,salary,12*salary+1000 from emp;
select sysdate,sysdate+1,sysdate-2 from dual; #日期函数只能做+,-
-
取别名
-
空格
select employee_id id from emp;
-
as
select employee_id as id,last_name as name,12*salary as annual_sal from emp;