SQL BASIC

DB2 SQL SUBQUERIES

SUBQUERIES SQL SubQuery is a query which inside another query. You can include a subquery in a WHERE or HAVING clause by using a basic or quantified comparison,the IN or the EXISTS keyword. Here is an example of SubQuery using IN Keyword. SELECT EMPNO, LASTNAME, JOB FROM EMPLOYEE WHERE EMPNO IN (SELECT EMPNO FROM EMPPROJACT WHERE PROJNO [...]










DOWNLOADS

QSql: GUI for DB2 for IBM i.