#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2013
    Posts
    3
    Rep Power
    0

    can i use


    sum(avg(case statement))
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    859
    Rep Power
    388

    Thumbs down


    Originally Posted by u0_java
    Hello everyone,

    does it gives the same result if i use oracle and sql stored proc. somehow im not same output for both though both are working fine.
    . . . E t c . . .
    my question is does both perform same function or not.
    Thanks in advance.
    It's difficult to compare incomplete statements.

    But...I believe the the AVG() function in the Oracle query does not match a SUM() function in the windoze sql query.
    Seems you need to lay off the sauce -->
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2013
    Posts
    3
    Rep Power
    0
    @LKBrwn_DBA

    i really appreciate your help. i figured it out and along with other one. i have posted complete sp's //forums.devshed.com/oracle-development-96/need-help-in-understanding-a-stored-proc-939566.htmlThanks

IMN logo majestic logo threadwatch logo seochat tools logo