Post reply

SQL Query to sum data up to

  • October 25, 2011 at 5:45 am

    #261876

    Hi All, I need to get the records with sum up to 1800. Having a table, in it on duration column the record's are stored in seconds, now need the query to sum the duration up to 1800 seconds and display them.

    Please help

  • October 25, 2011 at 3:09 pm

    #1399331

    It sounds like a Running Total scenario. Google might help to return a more detailed information.

    Depending on the SQL skills available, the "quirky update" method might be an option, too.

    Without more information from your side it's hard to provide a more detailed answer.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply