Analytic Functions
Started by Cristian Custodioabout 23 years ago1 messagesgeneral
Does anybody know tell me whether the PG have
analytic functions like the LEAD of Oracle?
I would like to create a SELECT where I can get
data of prior row like following example:
LAST_NAME HIRE_DATE Date of prior row
--------- --------- ---------
Raphaely 07-DEC-94 18-MAY-95
Khoo 18-MAY-95 24-JUL-97
Tobias 24-JUL-97 24-DEC-97
Baida 24-DEC-97 15-NOV-98
Himuro 15-NOV-98 10-AUG-99
Colmenares 10-AUG-99
On Oracle I can also to make this using ROWNUM.
Does anybody already need to make this
or have any soluction about it...
Thanks,
Cristian