Home » SQL & PL/SQL » SQL & PL/SQL » How to fatch the data from previous row (oracle 10g)
How to fatch the data from previous row [message #340249] Tue, 12 August 2008 01:55 Go to next message
bhadresh4u
Messages: 41
Registered: May 2005
Location: Japan
Member
how can i fatch data from previous row in a single sql query
Re: How to fatch the data from previous row [message #340252 is a reply to message #340249] Tue, 12 August 2008 01:57 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Have a look at LAG/LEAD functions.

Regards
Michel
Previous Topic: sql query
Next Topic: Tree structure query
Goto Forum:
  


Current Time: Tue Feb 18 23:04:06 CST 2025