I need a query to restrict the row count in derby. luckily it got implemented in derby 10.4.1.3 but there are few limitations.
one of the limitations as follows..
the above doc is saying, we cant use where clause along with ROW_NUMBER function
SELECT * FROM (====================
ROW_NUMBER() OVER () AS R,
) AS TR
WHERE R <= 10;