JOIN NOW

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

Related Questions