How to convert MYSQL Query to support with Derby database

I used below mention query to cerate report in My Project with MYSQL with Java NetBeans. It works successfully. SELECT CASE WHEN sortId = 1 THEN CAST(orderId AS CHAR(10)) ELSE '' END AS orderId, CASE WHEN sortId = 1 THEN orderName ELSE '' END AS orderName, itemName, itemUnit, itemRate FROM ( SELECT orderId, orderName, itemName, itemUnit, itemRate, ROW_NUMBER() OVER (PARTITION BY orderId ORDER BY itemId) AS sortId FROM ( SELECT orderId, orderName, itemName, itemUnit, itemRate, itemId FROM tblitem INNER JOIN tblorder on tblorder.orderId = tblitem.orderRef ) orderItems ) orderItemsSorted ORDER BY orderItemsSorted.orderId, orderItemsSorted.sortId Later I wanted to use Derby Database in Netbeans. When I attempted to use that Query makes error message Syntax error: Encountered "PARTITION" at line 4, column 81. To avoid this problem can I use "The result offset and fetch first clauses" in Derby? Thanks in advance to help me to convert or change this query to work in Derby. I Below mentioned table creation and join Quires TBLORDER (Order Table) CREATE TABLE TBLORDER ( ORDERID INTEGER, ORDERNAME VARCHAR (50), PRIMARY KEY (ORDERID) ); TBLITEM (Item Table) CREATE TABLE TBLITEM ( ITEMID INTEGER, ITEMNAME VARCHAR (50), ITEMUNIT VARCHAR (10), ITEMRATE DOUBLE, ORDERREF INTEGER, PRIMARY KEY (ITEMID) ); CREATE FOREIGN KEY ALTER TABLE NAME.TBLITEM ADD FOREIGN KEY (ORDERREF) REFERENCES NAME.TBLORDER (ORDERID) JOIN QUERY SELECT ORDERID, ORDERNAME, ITEMNAME, ITEMUNIT, ITEMRATE FROM TBLITEM INNER JOIN TBLORDER ON TBLORDER.ORDERID = TBLITEM.ORDERREF