SQL Tutorial

SQL DELETE Statement in DB2 for i SQL

SQL DELETE Statement in DB2 for i SQL The DELETE statement is used to delete the existing rows in a table. DELETE syntax DELETE FROM table_name…

SQL UPDATE Statement in DB2 for i SQL The UPDATE statement is used to modify the existing records in a table or a view. UPDATE syntax UPDATE ta…

Inserting rows using a select-statement in DB2 for i SQL We can use SELECT statement within an INSERT statement to insert rows into the table spec…

SQL INSERT INTO Statement in DB2 for i SQL The INSERT INTO statement is used to insert single or multiple records in a table or view. Syntax us…

FETCH FIRST clause in DB2 for i SQL FETCH FIRST clause is used to specify the number of rows to return in the SELECT statement. Syntax using FET…

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…