d_LIMIT_OFFSET.sql

-- Using limit to select the top result
SELECT county, station, max(temp) as max_temp, min(temp) as min_temp
FROM hrly_Irish_weather
WHERE county = "Cork"
GROUP BY county, station
ORDER BY max_temp DESC
LIMIT 1;
-- Using limit to select the top result, adding an offset to start after the second line
SELECT county, station, max(temp) as max_temp, min(temp) as min_temp
FROM hrly_Irish_weather
WHERE county = "Cork"
GROUP BY county, station
ORDER BY max_temp DESC
LIMIT 1
OFFSET 2;