You can use the "LAG" function. I'll give an example later when I have the time. Right now I have an undead rogue that needs leveling up.
On Thu, Oct 2, 2008 at 3:12 AM, Rob Wolfe <[EMAIL PROTECTED]> wrote: > > > > On Oct 2, 5:11 am, "rockstar apps" <[EMAIL PROTECTED]> wrote: > > Hi > > > > I have 3 columns in my table. > > > > Table name: Test > > Columns : sno UserName Startdate Enddate > > 1 scott 1-sep-2008 > 30-sep-2008. > > 2 tiger > > My requirement is i need to display the Enddate of first user as > Startdate > > of second user. > > > > Waiting for your reply. > > > > Regards. > > Rockstar > > With the new school year this is probably a good time to remind folks > that this is probably not the best group to come to if you are looking > to get classroom assignments solved. No offense meant to the poster > if that isnt the case but this one really has that classroom aroma to > it. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
