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
2 Likes
Answer
SELECT ename, Sal / 12 AS MonthlySalary
FROM emp;
Answered By
2 Likes
|
Suppose there is annual salary information provided by emp table. How can we fetch monthly salary of each and every employee?
2 Likes
SELECT ename, Sal / 12 AS MonthlySalary
FROM emp;
Answered By
2 Likes