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

Report message to a moderator

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: 68771
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Have a look at LAG/LEAD functions.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 28 22:11:49 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.