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