SELECT * FROM
( SELECT JBXX.*,row_number() OVER (partition BY WRYMC ORDER BY WRYMC,CJSJ DESC) R
FROM T_WRY_JBXX JBXX
) A WHERE R=1
( SELECT JBXX.*,row_number() OVER (partition BY WRYMC ORDER BY WRYMC,CJSJ DESC) R
FROM T_WRY_JBXX JBXX
) A WHERE R=1