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.
Oracle Code:
Output:
need an explanation for this answer? contact us directly to get an explanation for this answer