Oracle: List the employees name and total salary of a year and yearly salary is more than $10000
Oracle Operator: Exercise-2 with Solution
Write a query to list the employees name and total salary of a year and yearly salary is more than $10000.
Sample table: employees
Sample Solution:
Oracle Code:
SELECT first_name, last_name, salary*12 "Yearly Salary"
FROM employees
WHERE (salary*12) >10000;
Output:
FIRST_NAME LAST_NAME Yearly Salary -------------------- ------------------------- ------------- Steven King 288000 Neena Kochhar 204000 Lex De Haan 204000 Alexander Hunold 108000 Bruce Ernst 72000 David Austin 57600 Valli Pataballa 57600 Diana Lorentz 50400 Nancy Greenberg 144096 Daniel Faviet 108000 John Chen 98400 ......................... 107 rows selected.
Pictorial Presentation:
Improve this sample solution and post your code through Disqus.
Previous: Write a query to list the name of all the employees who are working in department number 20.
Next: Write a query to list the employees name and salary who’s daily salary is more than $100.
What is the difficulty level of this exercise?
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework