Derived Table Vs. Sub-Query – Here are Top Differences

Derived Table in DB2 is a solution to avoid complex SQL query. After deriving you use that table whenever you need in that main SQL query.