Post reply

Rewrite this query to calculate the MIN, AVERAGE, and MAX of the Temperature field.

  • May 22, 2018 at 10:30 am

    #360486

  • May 22, 2018 at 10:53 am

    #1991466

    haseebrahman7 - Tuesday, May 22, 2018 10:30 AM

    Is this a blog post, or do you have a question?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • May 22, 2018 at 11:11 am

    #1991470

    Question is how would I rewrite this query to calculate the MIN, AVERAGE, and MAX of the Temperature field

  • May 22, 2018 at 11:17 am

    #1991472

    haseebrahman7 - Tuesday, May 22, 2018 11:11 AM

    Question is how would I rewrite this query to calculate the MIN, AVERAGE, and MAX of the Temperature field

    With no grouping?
    Just remove RecordDate, Latitude and Longitude from the SELECT list and remove the entire GROUP BY clause.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • May 22, 2018 at 11:21 am

    #1991476

    Thank u

Viewing 5 posts - 1 through 4 (of 4 total)

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