11g 썸네일형 리스트형 [Oracle] 11g R2 : NTH_VALUE Function NTH_VALUE Function The NTH_VALUE function enables you to find column values from an arbitrary row in the window. This could be used when, for example, you want to retrieve the 5th highest closing price for a company's shares during a year. The LAG and LEAD functions can be thought of as being related to, and a simplification of, the NTH_VALUE function. With LAG and LEAD, you can only retrieve va.. 더보기 이전 1 다음