DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011

    Running total query

    Thanks in advance for your suggestion and help. When I execute the query below

    select site_id,count (order_id) as ORDCNT
    from itc_com_order_header
    where platform_id='GT'
    group by site_id
    order by ordcnt desc


    470 1239
    662 491
    581 150

    What I want/expected output
    SITE_ID ORDCNT Running Total
    470 1239 1239
    662 491 1730
    581 150 1880

    How do i do that in ORACLE?

  2. #2
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    Either write the output of your first query into a temp table or wrap it up as an inline view; then use sum() analytical function to display running total.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.