AS400 and SQL Tricks

SQL LIMIT clause in DB2 for i SQL LIMIT clause The LIMIT clause is used to select the limited number of records. LIMIT syntax SELECT column…

SQL CASE expressions in DB2 for i SQL CASE statement The SQL CASE statement is a conditional statement. The CASE statement works like a simple IF…

SQL ALL operator in DB2 for i SQL ALL operator The SQL ALL operator allows us to perform a comparison between a single column value or a range o…

SQL ANY Operators in DB2 for i SQL ANY operator The SQL ANY operator allows us to perform a comparison between a single column value or a range o…

SQL INTERSECT keyword in DB2 for i SQL INTERSECT keyword The INTERSECT keyword returns the rows that are same between the result set of two or …

SQL EXCEPT keyword in DB2 for i SQL EXCEPT keyword The EXCEPT keyword returns the rows from the first sub-select query minus any matching rows fr…

SQL UNION in DB2 for i SQL SQL Union operator UNION keyword is used to combine results of two or more SELECT statement to form a full select. Th…

How SQL multiple Join Works SQL Multiple Joins A SQL query that contains the same or different join types, which are used more than once. Theref…

SQL SELF JOIN in DB2 for i SQL Self Join A self join is a regular join, but the table is joined with itself. Syntax SELECT column_name(s) F…

SQL JOIN in DB2 for i SQL A JOIN clause can be used to combine rows from two or more tables based on some related columns between them. We can sele…

SQL FULL OUTER JOIN in DB2 for i SQL Full Outer Join A full outer join returns matching rows from both tables along with nonmatching rows from bot…

SQL CROSS JOIN in DB2 for i SQL Cross Join A cross join is also known as Cartesian Product JOIN. Cross Join returns the result table where each…

SQL EXCEPTION JOIN in DB2 for i SQL EXCEPTION JOIN A left exception join returns only those rows from the first table that do not have a match …

SQL RIGHT OUTER JOIN in DB2 for i SQL Right Outer Join A right outer join returns all the rows that an inner join returns plus one row for each…

SQL LEFT OUTER JOIN in DB2 for i SQL Left Outer Join A left outer join returns all the rows that an inner join returns plus one row for each of th…

SQL INNER JOIN in DB2 for i SQL INNER JOIN An INNER JOIN returns only those rows from each table in JOIN condition that have matching values in…

SQL NOT operator in DB2 for i SQL The SQL NOT operator is used in combination with other operators to give the opposite result/negative result. …

The OR operator is used with SQL WHERE clause . The OR operator is used to filter data based on one or more condition. The OR operator displays …

SQL AND operator in DB2 for i SQL The AND operator is used with SQL WHERE clause . The AND operator is used to filter data based on one or more con…

SQL Aliases in DB2 for i SQL SQL Aliases are the temporary name given to a table or its column while executing any SQL query. This makes us to pro…

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…