Answer the question
In order to leave comments, you need to log in
Invalid identifier in the request. How to fix?
There is a table EMPLOYEES(EMPLOYEE_ID,FIRSTNAME,LASTNAME,PATRONYMIC,BIRTHDATE)
You need to make queries and select those who were born in the spring. But ORACLE throws an error ORA-00904 invalid identifier. It's all about the last line with WHERE
SELECT EMPLOYEE_ID,
(LASTNAME || ' ' || FIRSTNAME || ' ' || PATRONYMIC) AS FULLNAME
FROM EMPLOYEES
WHERE MONTH(BIRTHDATE) BETWEEN 3 AND 5;
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question