Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 15 of 79

Database Query using SQL — Question 7

Back to all questions
7
Question

Question 7

Suppose there is annual salary information provided by emp table. How can we fetch monthly salary of each and every employee?

Answer 
SELECT ename, Sal / 12 AS MonthlySalary 
FROM emp;