ORACLE,SQLSERVER等数据库如何获取某张表中相同字段最近一条数
时间:2022-03-13 23:45
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