1. sum 函数
syntax:
select sum(column_name) from table |
select sum(column_name) as new_column_name from table |
select sum(column_name) from table group by itemtype |
2. Oracle 数据库连接
SELECT RDB_INSERT.T_BASE_STATION.LON, RDB_INSERT.T_BASE_STATION.LAT,
RDB_INSERT.AWS_TIMEDATA.PRECIPITATION,
RDB_INSERT.AWS_TIMEDATA.DRYBULTEMP,
RDB_INSERT.T_BASE_STATION.SNAME
FROM RDB_INSERT.T_BASE_STATION INNER JOIN
RDB_INSERT.AWS_TIMEDATA ON
RDB_INSERT.T_BASE_STATION.SNO = RDB_INSERT.AWS_TIMEDATA.STATIONNUM
WHERE (RDB_INSERT.T_BASE_STATION.AREA = '西安地区') AND
(RDB_INSERT.AWS_TIMEDATA.OBSERVTIMES = '201011091420')
3. 牛B select 语句
select table1.maxwindD, table2.maxwindD, table1.StationNum
from
(Select maxwindD, StationNum from tabTimedata where ObservTimes='2010100911') as table1
left join
(Select maxwindD, StationNum from tabTimedata where ObservTimes='2010100905') as table2
on table1.StationNum = table2.StationNum