SQL数据使用实例展示

常规使用

SELECT * 
FROM T_LOCALOBTMIND_ARH_2020
WHERE DDATETIME >= TO_DATE('2020-05-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
AND DDATETIME <= TO_DATE('2020-05-06 00:00:00', 'yyyy-mm-dd hh24:mi:ss')

多表链接查询、排序合并

Select 后的内容为排序合并
From 后的内容为链接查询
On 后的内容为链接共同对象

SELECT 
	a.DDATETIME,a.OBTID,
	b.WD10AVEDF2,b.WD10AVEDD2,
	a.WD10DF,a.WD10DD,a.WDIDF,a.WDIDD,
	b.T10M,a.T,b.TROAD,
	b.RH10M,a.U,
	b.DP10M,a.DP,a.P,
	a.MINR,a.HOURR,
	b.GEOT5CM,b.GEOT10CM,b.GEOT20CM,b.GEOT40CM,
	b.SOILM20CM,b.SOILM40CM,
	b.SHF10CM,b.SHF20CM,
	c.V,b.CD,
	b.RADDL,b.RADDS,b.RADUL,b.RADUS
FROM
	(
	SELECT 
		DDATETIME, OBTID, 
		WDIDF, WDIDD, WD10DF, WD10DD,
		T, U, DP, P, MINR, HOURR 
	FROM T_LOCALOBTMIND_ARH_2020 
	WHERE OBTID ='G3686'
	AND DDATETIME >= TO_DATE('2020-05-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
	AND DDATETIME <= TO_DATE('2020-05-06 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
	) a
JOIN 
	(
	SELECT
		DDATETIME,OBTID,
		WD10AVEDF2,WD10AVEDD2,
		T10M,DP10M,DP2M,RH10M,
		TROAD,GEOT5CM,GEOT10CM,GEOT20CM,GEOT40CM,
		SOILM20CM,SOILM40CM,SHF10CM,SHF20CM, 
		CD,RADDL,RADDS,RADUL,RADUS
	FROM T_CLIMATESTATIONADD 
	WHERE OBTID ='G3686'
	AND DDATETIME >= TO_DATE('2020-05-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
	AND DDATETIME <= TO_DATE('2020-05-06 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
	) b ON a.DDATETIME=b.DDATETIME and a.OBTID=b.OBTID
JOIN
	(
	SELECT
		DDATETIME,OBTID,
		V
	FROM T_LOCALOBTV
	WHERE OBTID ='G3686'
	AND DDATETIME >= TO_DATE('2020-05-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
	AND DDATETIME <= TO_DATE('2020-05-06 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
	) c ON b.DDATETIME=c.DDATETIME and b.OBTID=c.OBTID

持续不定期更新！咕咕咕！咕咕！