Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: writing sql.....9i

    Hi

    I may have asked this before but cannot find the thread, anyhow, all I'm trying to do is:

    Data is loading into a table at 15 min intervals and the values coming in are accmulative. I wanted to write a query which would show the difference between each successive row. Would appreciate any suggestions.

    Regards
    Shajju

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    a query which would show the difference between each successive row
    Research use of LAG and LEAD analytical functions.

  3. #3
    Join Date
    Aug 2008
    Posts
    464
    Thanks. Much Appreciated.

  4. #4
    Join Date
    Feb 2006
    Posts
    173
    Provided Answers: 1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •