The best example for TRUNC function that truncates to nearest date format in SQL
The GROPU BY clause is very much interesting and it is being used in many sql development project. The summary and key points given here like that you never forgotten about what is Group BY in sql. The SQL is well explained with an example. Read more.
SQL -305 error code and quick resolution to handle it in your programs
The Associate cursor in DB2 is being used in Stored procedure. The purpose is while calling a Stored procedure from an another stored procedure this Associate acts as to hold result set.