通用的SQL

-------查询物理版本最大并且去除业务版本的重复-------
select a.*
  from ecm02 a,
       (select BUSINESS_VER, max(PHYSICAL_VER) PHYSICAL_VER
          from ecm02
         where REPOSITORY_NAME='TEST' and  


FILE_PATH='_TEST_DEPLOYE_jQueryAPI-100214' 
group by BUSINESS_VER) b
 where a.BUSINESS_VER = b.BUSINESS_VER
   and a.PHYSICAL_VER = b.PHYSICAL_VER




--查询最大physical sql---
select a.*from ecm02 a,(select max(PHYSICAL_VER) PHYSICAL_VER from ecm02 


where REPOSITORY_NAME='TEST' and  FILE_PATH='_TEST_DEPLOYE_jQueryAPI-


100214')b where a.PHYSICAL_VER = b.PHYSICAL_VER