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: 64275
Registered: March 2007
Location: Nanterre, France, http://...
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: Thu Jan 19 13:49:31 CST 2017

Total time taken to generate the page: 0.15641 seconds