Oracle: List the employees name and salary who’s daily salary is more than $100

Oracle Operator: Exercise-3 with Solution

Write a query to list the employees name and salary who’s daily salary is more than $100.

Sample table : employees

Sample Solution :-

Oracle Code :

SELECT first_name, last_name, salary 
FROM employees 
WHERE (salary/30) >100;

Output:

FIRST_NAME           LAST_NAME                     SALARY
-------------------- ------------------------- ----------
Steven               King                           24000
Neena                Kochhar                        17000
Lex                  De Haan                        17000
Alexander            Hunold                          9000
Bruce                Ernst                           6000
David                Austin                          4800
Valli                Pataballa                       4800
Diana                Lorentz                         4200
Nancy                Greenberg                      12008
Daniel               Faviet                          9000
John                 Chen                            8200
.........................

81 rows selected.

Pictorial Presentation:

Improve this sample solution and post your code through Disqus.

Previous: Write a query to list the employees name and total salary of a year and yearly salary is more than $10000.
Next: Write a query to list the name of all the employees who are not working in department number 20.