仅在 DB2 中参数化 FETCH FIRST n ROWS [英] Parameterize FETCH FIRST n ROWS ONLY in DB2

问题描述

我正在尝试执行以下操作:

I'm trying to do the following:

  select * 
  from table      
  fetch first @param rows only

@param 是一个整数.

@param is an int.

DB2 不会有它.我听说过将它与 || 连接，但我似乎无法让它发挥作用.

DB2 would not have it. I've heard of concatenating it with ||, but I can't seem to get that to work.

有人有这方面的经验吗?

Anyone have experience with this?

(PS 我看到一个类似问题) 但不理解他使用 ':1' 的方法.

(PS I saw a similar question) but didn't understand his approach using ':1'.

推荐答案

您可以尝试以下方法:

select t.*
from (select r.*, row_number() over() as row_num  
      from table r) as t
where row_num <= @param

这篇关于仅在 DB2 中参数化 FETCH FIRST n ROWS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！