salary management 源代码

select count(*) as '人数' from employees where salary>3000

select max(salary) as '最高工资',min(salary) as '最低工资',avg(salary) as '平均工资' from employees

select top 3 employees.* from employees order by employees.salary desc

update employees set salary=600 where salary is null

select count(*) as '人数' from employees where salary>3000

-------------------------------------------------------------------- --最高税率：

using System; using System.Web.Services; //计算所得税的类，继承了WebService public class TaxService : WebService { //计算每月工薪要交的个人所得…

--工资低于2500的都加上200 update employees set salary=salary+200 where salary4000 --查询position 含有 经理的字样的员工信息 select * from employees…

Name Salary ------------------- ---------- Hank Williams 28422.82 Buddy Holly 39292.22 Ot…

Name Salary ------------------- ---------- Hank WilliamsABCDEFGHIJ28422.82 Buddy Holly 39292.22 …