请问这句话使用POSTGRES如何实现?
WITH t AS (SELECT ROW_NUMBER() OVER (ORDER BY b.[序号] ASC) AS rowNo , * FROM [fxbtable] b ( NOLOCK )) SELECT * FROM t WHERE t.rowNo BETWEEN 1 AND 11-1
[解决办法]
把nolock去掉,把方扩号去掉
postgresql的语法和oracle类似
有7天时间去问,不如花一天时间去看其文挡.
发布时间: 2012-05-04 12:36:09 作者: rapoo
请问这句话使用POSTGRES如何实现?
WITH t AS (SELECT ROW_NUMBER() OVER (ORDER BY b.[序号] ASC) AS rowNo , * FROM [fxbtable] b ( NOLOCK )) SELECT * FROM t WHERE t.rowNo BETWEEN 1 AND 11-1
[解决办法]
把nolock去掉,把方扩号去掉
postgresql的语法和oracle类似
有7天时间去问,不如花一天时间去看其文挡.