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

Question

Post reply

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

haseebrahman7

Valued Member

Points: 54
More actions
May 22, 2018 at 10:30 am

#360486

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

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

Phil Parkin SSC Guru Points: 247202 More actions · Answer 1

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

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

haseebrahman7 Valued Member Points: 54 More actions · Answer 2

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

Phil Parkin SSC Guru Points: 247202 More actions · Answer 3

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.

haseebrahman7 Valued Member Points: 54 More actions · Answer 4

haseebrahman7

Valued Member

Points: 54

May 22, 2018 at 11:21 am

#1991476

Thank u