select s.grade
      ,max(s.height)over(partition by s.grade order by s.height asc
                         rows between unbounded preceding and unbounded following) as 키
      ,last_value(s.name)over(partition by s.grade
                              order by s.height desc nulls last
                              rows between unbounded preceding and unbounded following) as 이름
from student s;

제가 위에 같은 꿔리를 짰는데요, 빨간 게 있고 없고에 따라서 결과가 다르더라고요. 그런데 제가 뇌자극 오라클 책에서 보길

"윈도우 절을 생략할 땐 Between unbounded preceding and unbounded following이 적용된다"라고 써 있는 걸 봤는데, 이거는 잘 못된 건가요?