AS400 and SQL Tricks

Using WHERE Clause in SELECT statement in DB2 for i SQL The WHERE clause can be used to specify the search condition that identifies the row or ro…

GROUP BY clause in DB2 for i SQL The GROUP BY clause allows us to group identical rows based upon one or more column or expressions and displays a …

HAVING clause in DB2 for i SQL The HAVING clause is used to specify the search condition for the groups selected by the GROUP BY clause. Means we…

ORDER BY clause in DB2 for i SQL The ORDER BY clause is used to sort the result set in ascending or descending order according to one or more colu…

Handling NULL values in DB2 for i SQL NULL value means that there is no value present for the column in a row in table. It is an unknown value. We…

Some Special Registers in SQL DB2 for i SQL We can use certain Special registers in our SQL queries. For example, CURRENT DATE, CURRENT TIME etc. t…

DISTINCT clause in DB2 for i SQL The SELECT DISTINCT statement is used to return only distinct rows i.e. different rows. It will avoid the duplica…

BETWEEN AND predicate in Search condition in DB2 for i SQL We can use various predicates in our WHERE clause condition such as BETWEEN, IN, EXIST…

IN predicate in Search condition in DB2 for i SQL It is used to get the rows that falls in the listed values in IN expression. For Example, refer…

EXISTS predicate in Search condition in DB2 for i SQL It is used to test the existence of certain rows. For Example, refer to the Customer table …

Basic Select statement in DB2 for i SQL We can use SELECT statement to retrieve data from the table/tables or view/views. We can use SELECT to ret…