Posted By

bbrumm on 02/20/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 02/20/17 08:36am

Statistics

Viewed 952 times

Favorited by 0 user(s)

Related snippets

Oracle LEAD Function

/ Published in: SQL

A few examples of the LEAD function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT * FROM student;
 
--Example 1
SELECT student_id, first_name, last_name, enrolment_date,
LEAD(enrolment_date) OVER (ORDER BY enrolment_date ASC) AS next_enr_date
FROM student
ORDER BY student_id ASC;
 
--Example 2
SELECT student_id, first_name, last_name, enrolment_date,
LEAD(enrolment_date) OVER (ORDER BY enrolment_date ASC) AS next_enr_date
FROM student
ORDER BY enrolment_date ASC;
 
--Example 3
SELECT student_id, first_name, last_name, enrolment_date,
LEAD(enrolment_date, 2, '31-DEC-2999') OVER (ORDER BY enrolment_date ASC) AS next_enr_date
FROM student
ORDER BY enrolment_date ASC;
 
 
--Example 3
SELECT student_id, first_name, last_name, enrolment_date,
LEAD(enrolment_date) OVER (ORDER BY enrolment_date ASC) AS next_enr_date
FROM student
WHERE LEAD(enrolment_date) OVER (ORDER BY enrolment_date ASC) > '01-FEB-2015'
ORDER BY enrolment_date ASC;