查询语句语法:
select [column_name...] from table_name[s]
where [conditional...]
group by [column_name] having...
order by [column_name] [asc/desc]
注:以下查询语句用到的是scott用户下的emp表
基本查询语句:
1.查询当前用户下的所有表:
select * from tabs;
2.给某个字段取别名:
select empno as eno from emp;
3.去重:
select distinct deptno from emp;
4.连接查询(将查询结果进行拼接显示):
select '姓名'||ename||'职位:'||job from emp;
5.空值的处理
select ename,(nvl(sal,0)+nvl(comm,0))*12 from emp;
6.排序:asc:顺序 desc:倒序
select ename from emp order by sal asc;
select ename,sal from emp order by sal desc;