- 博客(6)
- 资源 (2)
- 问答 (1)
- 收藏
- 关注
原创 Oracle子查询
--子查询--认识字查询select min(sal) from emp;select * from emp where sal=(select min(sal) from emp);--在where字句中使用子查询select sal from emp where ename='ALLEN';select * from em
2014-06-30 18:01:51 475
原创 Oracle分组统计查询
--分组统计查询--统计函数select sum(sal) from emp;select avg(sal),round(avg(sal),2),max(sal),min(sal) from emp;select min(hiredate) 最早雇佣日期,max(hiredate) 最晚雇佣日期 from emp;select media
2014-06-29 16:41:22 443
原创 Oracle多表查询
--多表查询--多表查询的基本语法select count(*) from emp;select count(*) from dept;select * from emp,dept;select * from emp,dept where emp.deptno=dept.deptno;--多表查询实例select
2014-06-28 10:51:28 462
原创 Oracle 单行函数
--单行函数--字符函数select upper('ChenFeiPeng') from emp;select upper('ChenFeiPegn'),lower('chenfeipeng') from dual;select * from emp where ename=upper('smith');select ename 原始姓名, initca
2014-06-27 18:46:08 419
原创 Oracle限定查询
--限定查询 select COUNT(*) from emp; select * from emp where sal>1500; select * from emp where sal select * from emp where ename='SMITH'; select * from emp where job='CLERK';
2014-06-26 17:40:38 347
原创 Oracle 简单查询
select * from emp;select empno,ename,job from emp; select job from emp;select DISTINCT empno,job from emp;select empno,ename,sal*12,sal/30 from emp;select empno,ename,sal
2014-06-26 15:32:32 327
oralce sql developer连接不上
2015-01-07
TA创建的收藏夹 TA关注的收藏夹
TA关注的人