Informatics Practices
Suppose there is annual salary information provided by emp table. How can we fetch monthly salary of each and every employee?
SQL Queries
1 Like
Answer
SELECT ename, Sal / 12 AS MonthlySalary
FROM emp;
Answered By
3 Likes
Suppose there is annual salary information provided by emp table. How can we fetch monthly salary of each and every employee?
1 Like
SELECT ename, Sal / 12 AS MonthlySalary
FROM emp;
Answered By
3 Likes