ROWS function available inside subquery

35 Views Asked by At

Can somebody explain why I'm not able to use the ROWS function inside a subquery?

I'm able to use the ROWS function with a standard SELECT statement but when using it inside a subquery, I get this error:

Invalid token.

Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 3, char 26.

This SQL is not working:

SELECT 
    (SELECT rel.NAME 
     FROM RELATIONS rel ROWS 1 /*<--*/
    ) AS rel1,
    PR.CODE,
    PR.OMS,
    ADM.ADMOMS
FROM 
    PROJECTS pr
JOIN
    ADMINISTRATIONS adm ON ADM.ID = PR.ADM_ID
WHERE 
    pr.STATUS < '008' AND
    pr.CODE = "1234"

However, this SQL IS working:

SELECT r.NAME 
FROM RELATIONS r ROWS 1 /*<--*/
0

There are 0 best solutions below