오라클 LEAD, LAG 함수 사용 (게시판 이전글, 다음글 구현시 사용)
LEAD Syntax Description of the illustration lead.gif See Also: "Analytic Functions" for information on syntax, semantics, and restrictions, including valid forms of value_expr Purpose LEAD is an analytic function. It provides access to more than one row of a table at the same time without a self join. Given a series of rows returned from a query and a position of the cursor, LEAD provides access..
프로그래밍/DB
2009. 4. 30. 10:34
