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: 64120
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: Tue Dec 06 12:36:52 CST 2016

Total time taken to generate the page: 0.10224 seconds