sql分组查询partition
摘要：
select b.STCD,b.STNM,t.EQPTP,t.EXKEYfrom ST_STBPRP_B bleft join ST_GATE_R t on b.STCD = t.STCDwhere t.TM = (select max(s.tm) as mtm from ST_GATE_R s w... 阅读全文
posted @ 2015-12-19 14:29 adamas 阅读(878) 评论(0) 推荐(0) 编辑
