首页 > 专家说

oracle 语句问题

来源:新能源网
时间:2024-08-17 13:28:38
热度:

oracle 语句问题【专家解说】:改成这样
select * from (select Row_Number() over (Order by agentcode) as rn

【专家解说】:改成这样 select * from (select Row_Number() over (Order by agentcode) as rn, a.* from commission a ) U where U.rn between 1 and 4 rowid是关键字