这句select row-number() over (order by ProductID asc) as RowIn

学习时间:2026-06-05 02:20:55 阅读：1649

这句select row_number() over (order by ProductID asc) as RowIndex,select row_number() over (order by ProductID asc) as RowIndex,p.ProductID,p.ProductName,p.CategoryID,p.Unit,p.UnitPrice,p.Quantity from Products as p where CategoryID = @CategoryID; 这句select row_number() over (order by ProductID asc) as RowIndex,

提问回复

最佳回答

虚心的星星

2026-06-05 02:20:55



这个是Oracle中比较常见的用法。[TEST2@orcl#19-4月 -11] SQL>select * from a;DTIME RCOUNT---------- ----------2011011101 22011011101 3[TEST2@orcl#19-4月 -11] SQL>select row_number()over(order by dtime ) as rowseq,dtime,rcount from a;ROWSEQ DTIME RCOUNT---------- ---------- ----------1 2011011101 32 2011011101 2主要用于查询数据的时候显示序号。over是Oracle的开窗函数。over(order by dtime ) 就是按照dtime排序并进行累加。对什么累加呢?就是前面的row_number()系统函数。你可以再试试sum(列)over(partition by id order by salary)等可以求工资的累加和。

这句select row-number() over (order by ProductID asc) as RowIn

最佳回答

最新回答共有2条回答

爱听歌的紫菜

热门文章

猜你喜欢