Как поправить функцию first?

Question

[evgenyt2000]

Не получается загнать первые времена ,как входной параметр начала трудовой деятельности

INSERT INTO TEACHER (HIREDATE)
SELECT HIREDATE
FROM LESSON 
WHERE (SELECT LESSONDATETIME,MIN(LESSONDATETIME) KEEP(DENSE_RANK FIRST ORDER BY LESSONDATETIME)
OVER (PARTITION BY TEACHERPC) FROM LESSON JOIN TEACHER ON TEACHER.PC_TEACHER=LESSON.TEACHERPC)

Answer 1

[Константин]

update teacher t
   set hiredate = (select min(lessondatetime)
                     from lesson l
                    where t.pc_teacher = l.teacherpc)