Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (140 points)
I want to write a stored procedure. I have total salary of each employee per month and the number of days employee was on leave in a month, in my database already. I first want to calculate the salary per day for each employee and then multiply it with the number of days employee was on leave, which will give me the amount to be deducted from the total salary. And finally calculating the new salary after leave deduction.

Please log in or register to answer this question.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Browse Categories

...