我正在尝试获取表\u a中的行数，将其保存在变量中，并获取表\u b中相同的行数。
CREATE VARIABLE myvar INTEGER;SET myvar = (SELECT count (*) FROM Table_A)SELECT * from Table_Bfetch first {mywar} rows ONLYDROP VARIABLE myvar;
CREATE VARIABLE myvar INTEGER;
SET myvar = (SELECT count (*) FROM Table_A)
SELECT * from Table_B
fetch first {mywar} rows ONLY
DROP VARIABLE myvar;
如何在db2中实现这一点？在这种情况下使用极限是不是更好？不使用变量能做到这一点吗？
x4shl7ld1#
你可以这样做。
SELECT * FROM( SELECT *, ROW_NUMBER() OVER() AS RN from Table_B)WHERE RN <= (SELECT COUNT(*) FROM Table_A)
SELECT * FROM
( SELECT *, ROW_NUMBER() OVER() AS RN from Table_B)
WHERE RN <= (SELECT COUNT(*) FROM Table_A)
1条答案
按热度按时间x4shl7ld1#
你可以这样做。