Home Forums SQLServerCentral.com Anything that is NOT about SQL! Each GROUP BY expression must contain at least one column that is not an outer reference. RE: Each GROUP BY expression must contain at least one column that is not an outer reference.

  • September 6, 2012 at 4:56 am

    #1534365

    Hi thanks,

    when I executed with modify query i got this as output

    hour date fuel-LEVEL FUEL_VOLUME

    102012-05-081195.96343612858.097037

    MY QUESTION IS IF I GIVE ONE PARTICULAR DAY IT SHOULD DISPLAY ALL THE DAY RECORDS BY SUMMING UP TO HOUR SO IT SHOULD DISPLAY LIKE HOUR

    0

    1

    2 AND RESPECTIVELY COLUMSN..

    CHEERS..