2015年12月19日

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 阅读(890) 评论(0) 推荐(0)

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:28 adamas 阅读(80) 评论(0) 推荐(0)

导航