当前位置：网站首页>3. Sort statement

3. Sort statement

2022-04-23 07:40:00 【Ah Dai cloth clothes cool】

3. Sort

1. Check all employee information , Sort by salary from low to high 

select * from emp
order by sal;

2. Inquiry Department 10 Of employees , Sort by salary from high to low , If the wages are the same , Sort by employment time from early to late 

select * from emp
where deptno=10 
order by sal desc,hiredate;

3. Check employee number 、 full name 、 Annual salary , Sort by annual salary from high to low 

select empno,ename,(sal+ifnull(comm,0)*12 income)
from emp
order by income desc;

版权声明
本文为[Ah Dai cloth clothes cool]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230622239491.html

边栏推荐

猜你喜欢

随机推荐