Q:

Write a Oracle query to list the names (first and last), salary of those employees whose salary is four digit number ending with Zero

0

Write a Oracle query to list the names (first and last), salary of those employees whose salary is four digit number ending with Zero.

All Answers

need an explanation for this answer? contact us directly to get an explanation for this answer

Oracle Code:

SELECT  first_name, last_name, salary 
FROM employees 
WHERE length (salary) = 4 and salary like ’%0’;

Output:

FIRST_NAME           LAST_NAME                     SALARY
-------------------- ------------------------- ----------
Alexander            Hunold                          9000
Bruce                Ernst                           6000
David                Austin                          4800
Valli                Pataballa                       4800
Diana                Lorentz                         4200
Daniel               Faviet                          9000
John                 Chen                            8200
Ismael               Sciarra                         7700
Jose Manuel          Urman                           7800
Luis                 Popp                            6900
Alexander            Khoo                            3100

........

88 rows selected.

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Similar questions


need a help?


find thousands of online teachers now