Table spaces are completely logical in any database. Many developers confused that they always access data from physical storage. But actually that is not correct. So this post clarifies how to define a table with logical storage. Sample SQL really helps you to understand quickly.
The fundamental point in DB2 SQL is set operator. So that you can filter data from multiple tables. Given these details such that a layman can understand quickly.
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.
Query to change Data Type ALTER TABLE BOOKS ALTER BOOKNAME SET DATA TYPE VARCHAR(200) ALTER ISBN SET DEFAULT ‘UNKNOWN’; Certain characteristics of a table cannot be
Today’s post What is stored procedure? How many types of stored procedures? What are those? A stored procedure is a user-written program that can be called by
How to remove duplicates: SELECT DISTINCT(Column_name) from test_table; The above query selects all distinct values. How to get only duplicate values: SELECT COL1, COL2,COL3,COUNT(*) FROM
What is Distributed computing environments: typically involve requests from users at one DBMS client that are processed by a DBMS server. The server DBMS is
When performing data modeling in preparation for designing a database, knowing that two entities are related to each other is not sufficient. In addition to