Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 02nd, 2009
LEAD(<expression, offset, default>)[(<query_partition_clause>)]
OVER (<order_by_clause>)SELECT submit_date, num_votes,LEAD(num_votes,1,0) OVER (ORDERBY submit_date)AS NEXT_VAL
FROM votes;