Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
SQL with statement window function error
Hello! I am trying to run a window function to rank the rows in order to remove any duplicates (code below). I am getting the error "ORA-00923: FROM keyword not found where expected". Also WITH is not highlighting as a keyword so I am wondering if something is causing the error there. Can anyone help with this?
WITH names as (
SELECT
DISTINCT(e.person_id) as ID,
papf.person_number,
e.first_name as first1,
e.last_name as last1 ,
to_char(e.LAST_UPDATE_DATE, 'yyyy/mm/dd') as updatedate1,
to_char(e.effective_start_date, 'yyyy/mm/dd') as startdate1 ,
to_char(e.effective_end_date, 'yyyy/mm/dd') as enddate1 ,
l.first_name as first2,
l.last_name as last2,
to_char(l.LAST_UPDATE_DATE, 'yyyy/mm/dd') as updatedate2,
to_char(l.effective_start_date, 'yyyy/mm/dd') as startdate2 ,
to_char(l.effective_end_date, 'yyyy/mm/dd') as enddate2
FROM per_person_names_f e
JOIN per_person_names_f l ON e.person_id = l.person_id
LEFT
Tagged:
0