Design a job

I have table(Emp) with the columns Eid,Ename,Sal,month(sal),year(sal) and DOB (say 15th-Jan-1981).
Design a job such that the output displays Ename,year(sal),tot(sal) and current age i.e. For Ex: 18 yrs

Questions by Alekhya ch

Showing Answers 1 - 3 of 3 Answers

barak

  • Nov 21st, 2014
 

Using Transformer Days Between and divided by 365 - we can check for year with 366 if that's a big deal .

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions