2. Java
  3. oracle 的 row

oracle 的 row

xiaoxiao2021-02-28  65

SELECT * FROM (

select

　　Row_number() OVER (PARTITION BY a1 ORDER BY a1) rn

　　from a

　　) where RN = 1

转载请注明原文地址: https://www.6miu.com/read-54574.html

技术

最新回复(0)