SQL Global Temporary Tables top Usage

Best example SQL query to create Global temporary table in DB2. This is temporary table applicable to current session. It is like scratch pad table also called an intermediate table

Join Vs Sub query

Top Join Vs Sub-query differences to learn

In DB2 Joins and Sub-queries are two different concepts frequently used in writing SQL queries. These absolutely know differences help you write SQL queries in much better way ,which give an excellent performance.