搞掂你

終於比我搞掂條sql啦。

我一定要post係度，因為我真係諗得好辛苦架。

SELECT
a.latitude latitude, a.longitude longitude, a.WMO_station
WMO_station, a.WMO_block WMO_block, b.level_ind pressure,
b.hhh height, b.dd wd, b.ff ws, b.tdtd dew_pt, b.ttint temp,
b.in_time in_time, b.rep_no rep_no, b.iym IYM, b.idh IDH,
b.obstime
FROM
uarepheader a, temp_level b
WHERE
b.level_ind = 200 AND b.obstime = To_Date('2006-07-06-12',
'yyyy-MM-DD-HH24') AND a.obstime=b.obstime AND
a.rep_no=b.rep_no
AND (a.WMO_station, a.WMO_block, a.in_time)
IN (
SELECT
u.WMO_station, u.WMO_block, Max(u.in_time)
FROM
temp_level t, uarepheader u
WHERE
t.level_ind = 200 AND t.obstime =
To_Date('2006-07-06-12', 'yyyy-MM-DD-HH24') AND
u.obstime=t.obstime AND u.rep_no=t.rep_no AND
u.latitude >=1400 AND u.latitude <=4600 AND
u.longitude >=9400 AND u.longitude <=14100
GROUP BY
u.WMO_station, u.WMO_block)
ORDER BY
a.WMO_station, a.WMO_block;