Two kinds of Joins equi join and inner join mostly a confusion to all SQL developers. The given clear differences highly useful so that a basic learner can understand quickly.
SQL query is executed in two phases. The number one is Query processor and the other one is storage engine.
Three SQL rules to create a view. This is almost same in DB2, Oracle and Teradata. Also given ready made best example on how to create view and also to get data from view using SQL Query.
The quick 3 minute SQL quiz a really good tool to test your SQL knowledge. Start trying it today.
The popular ways to prevent deadlock in database while dealing with SQL queries written clearly such that even layman can understand quickly.
The power of RDBMS depends on certain rules placed. These rules are called as integrity rules. Those are entity integrity and referential integrity.
The best example for Java stored procedure in DB2, also given java class path to write stored procedure and explained how to include it in the DB2 stored procedure standard block. Read more.
There are many of the occasions while writing SQL query you will come across this kind of scenario that you need in the result only digits. To achieve this explained with examples of DB2 function DIGITS. This is also called column function.