MySQL Exercise: Display the name, salary and PF of all employees
MySQL Restricting and Sorting Data: Exercise-10 with Solution
Write a query to display the name (first_name, last_name), salary and PF (15% of salary) of all employees.
Sample table: employees
SELECT first_name, last_name, salary, salary*.15 PF from employees;
Pictorial Presentation of the above query
MySQL Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous:Write a query to display the jobs/designations available in the employees table.
Next:Write a query to select all records from employees where last name in 'BLAKE', 'SCOTT', 'KING' and 'FORD'.
What is the difficulty level of this exercise?