Oracle数据查询
Oracle、SQL等数据库常用的语言命令有增、删、改、查
查询相关代码
参考oracle数据库常用的99条查询语句:
1. 从TableName中查找满足Condition1和Condition2的Attr1和Attr2,且Attr2的取值区间[Lower,Upper]并按照Attr3降序排列
select Attr1,Attr2 from TableName where Condition1 and Condition2 and Attr2 between Lower and Upper order by Attr3 desc
#升序:order by Attr3 asc或order by Attr3
#降序:order by Attr3 desc
- in,not in,like,like’_M%’,like’%M%’的用法
in和not in后是list or set
select * from emp where ename in('SMITH', 'ALLEN', 'KING');
#说明:要求查询出姓名是 smith, allen, king 的雇员信息
select * from emp where empno not in(7369, 7499, 7521);
#说明:要求查询出雇员不是 7369, 7499, 7521 的雇员的具体信息
select * from emp where ename like '_M%';
#说明:查询出所有雇员姓名中第二个字母包含 "M" 的雇员信息
select * from emp where ename like '%M%';
#说明:查询出雇员姓名中包含字母 M 的雇员信息