select * from (select Row_Number() over (Order by agentcode) as rn">

首頁 > 專家說

oracle 語句問題

來源:新能源網(wǎng)
時(shí)間: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是關(guān)鍵字
2024-08-17
  • 怎樣將一個(gè)頁面文本框中的內(nèi)容作為另一個(gè).asp文件中select語句的關(guān)鍵字
    2024-08-17