select mid,us_phone,substr(us_phone,-3) as tail from tb_cy_memberinfo order by 3 null first/last;-- 3只能出现在order by 中,
select translate(‘ab12cc’,’-12345’,’-’) from dual;
select ename,sal, case when sal>1000 then 1 else 2 end as 级别 from emp order by 3,2 ;
select ename,sal from emp order by case when sal>1000 then 1 else 2 end, 2; --同上一条一样
select e.empno,e.ename,d.dname,d.loc from emp e inner join dept d on (e.deptno=d.deptno) where e.deptno=10;–sql-92标准
select e.empno,e.ename,d.dname,d.loc from emp e, dept d where e.deptno=d.deptno and e.deptno=10;
排序
最新推荐文章于 2023-01-24 00:13:16 发布