达梦数据库,分组查询多个字段group by 分组问题 :
select
d.cur_code,
d.cur_date,
d.DIRE_RATE
from
(
select
*,
Row_Number() OVER (partition by CUR_CODE order by cur_date desc) rank
from
MA_ELE_RATE
) as d
where
1 =1
and d.rank =1;
- “partition by”:后面放需要分组的字段,可一个也可多个,这一行为分组关键 分组字段为“CUR_CODE ”
- “ rank”:根据条件并取的结果取 ,最上面一条,也可取多条