如果他有2年的经验，员工薪水增加15％？ table name = employee_info列是emp_id; emp_name; salary; dateofjoin。使用SQL或SQL SERVER [英] increment the employee salary 15% if he has 2 years of experience? table name=employee_info columns are emp_id;emp_name;salary;dateofjoin. using SQL or SQL SERVER

问题描述

请快速回复我......我有以下要求..

如果他有2年的经验，员工工资增加15％？

table name = employee_info

列是

emp_id; emp_name; salary; dateofjoin。



使用SQL或SQL SERVER



请快速回复我...我正急切地等待。

please reply me fast ......i have a requirement as below..
increment the employee salary 15% if he has 2 years of experience?
table name=employee_info
columns are
emp_id;emp_name;salary;dateofjoin.

using SQL or SQL SERVER

please reply me some one fast...i am waiting eagerly.

推荐答案

It应该是这样的..

It should be something like this..

SELECT salary + (salary * 15/100) as NewSalary, emp_name
FrOM employee_info
Where DATEDIFF(MONTH, dateofjoin, GETDATE())/12 =2

SELECT salary + (salary * 15/100) as Salary, emp_name
FrOM employee_info
Where DATEDIFF(MONTH, dateofjoin, GETDATE())/12 =2

CREATE TABLE #EMP(EmpID INT,EmpName VARCHAR(50),Salary MONEY,DOJ DATE);

INSERT INTO #EMP VALUES(1215,'HARISH',20000,'23-MAY-2015'),
                       (1234,'SaiKiran',30000,'23-DEC-2013'),
		       (1234,'SatishREDDY',15000,'05-AUG-2016'),
		       (1234,'Santosh',25000,'03-JUL-2015');

  UPDATE #EMP  
     SET Salary=salary+Salary*.15 
           WHERE DATEDIFF(YEAR,DOJ,GETDATE())=2;

SELECT * FROM #EMP;
----------------------------------------------
EmpID	EmpName	      Salary	DOJ
-----------------------------------------------
1215	HARISH	     23000.00	2015-05-23
1234	SaiKiran     30000.00	2013-12-23
1234	SatishREDDY  15000.00	2016-08-05
1234	Santosh	     28750.00	2015-07-03

这篇关于如果他有2年的经验，员工薪水增加15％？ table name = employee_info列是emp_id; emp_name; salary; dateofjoin。使用SQL或SQL SERVER的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！