Sub Query and Correlated Sub query the real differences and useful for Database or SQL developers
Replace is most common in the production environment. There are many occasions we need to do…
The SQL functions are highly beneficial for SQL developers and ETL developers. Read best examples on TRIM, LTRIM and RTRIM.
Source: It career coach SQL QUERY DEVELOPMENT MODULE 1: THE SELECT STATEMENT What is the…
The four different types of SQL functions to read quickly and to get knowledge instantly.
RDBMS means relational database management system. This post gives an idea on top rdbms databases.
Cast function in SQL useful to covert one data-type to other,
CAST function rules to convert NULL value as an integer of Char.
As a routine, I am listening to mind music. Then I got an idea to…
DB2 performance you can improve by following these ideas useful for your project.
DB2 SQL error codes given for interviews as well as to use in your development or production support project.