Write a Oracle query to list the names (first and last) of those employees whose first name has only five characters and last name have third alphabet ends with 's'
- اوراكل
- 2021-10-12
- mhanasmh00489829403
الأجوبة
Oracle Code:
SELECT first_name, last_name
FROM employees
WHERE length(first_name) = 5 and last_name like ’__s%’;Output:
FIRST_NAME LAST_NAME -------------------- ------------------------- David Austin Laura Bissot Clara Vishney
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال
معلومات ذات صلة