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
asked Feb 21, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Jan 17, 2021 in BI by Chris (11.1k points)

Browse Categories

...