oracle查询。
1.显示操作时间
set timing on,
2.复制加入
insert into users(userid,username,userpss) select * from users;
3.显示记录条数
select count(*) from users;
4.去重复查询
select distinct deptno,job from emp ;
5.如何处理null值
select sal*13+nvl(comm,0)*13 '年工资' ,empName from emp;
含义:如果奖金为空,乘以0,否则,乘以comm;
6.日期查询
select ename,hiredate from emp where hiredate>'1-1月-1982'
7.in查询
select * from emp where empno in (122,234,256);
1.显示操作时间
set timing on,
2.复制加入
insert into users(userid,username,userpss) select * from users;
3.显示记录条数
select count(*) from users;
4.去重复查询
select distinct deptno,job from emp ;
5.如何处理null值
select sal*13+nvl(comm,0)*13 '年工资' ,empName from emp;
含义:如果奖金为空,乘以0,否则,乘以comm;
6.日期查询
select ename,hiredate from emp where hiredate>'1-1月-1982'
7.in查询
select * from emp where empno in (122,234,256);