
Last seen: Apr 12, 2022
Let me know in case of any queries.
Let us consider the simple calendar table for this example SQL date format dd mm yyyy and date format YYYYMMDD examples. date format ddmmyyyy ...
Let us see how to write a query to count the number of invoices with practical examples. Invoice ID is a unique ID or a table column that exists...
A view is a virtual table in the database and it can be derived from two or more tables. Instead of writing complex queries every time we can store ...
Normalization is a processes of splitting larger set of tables into smaller tables to reduce redundancy in the database (duplicate data). It avoid ...
Generally in the junk dimension, we keep cartesian products of all the attributes possible values. creation of the junk dimension provides an easy w...
A fact is an entity that provides quantitative information about the business. We store these numeric entities into a fact table. There are 3 types ...
The data present in the dimensional table changes from time to time. For example, the customer is staying in India for two years and then he moved to ...
Sart schema and Snowflake schemas play an important role in Data Warehouse. Start Schema: One fact table in the middle and surrounded by many dim...
Hello, I will explain to you the major difference between OLTP and OLAP. 1) OLTP: Online Transaction Processing System. All transactional da...
You can try the below query. Just change the table names and column names as per your requirement. SELECT B.CountryIDFROM TableB AS B LEFT JOIN Tabl...
SELECT TRUNC((SYSDATE - TO_DATE(DOB, 'YYYY-MM-DD'))/ 365.25) AS AGE_ASOFTODAY FROM DUAL; It is one of the easiest way to write a query to achieve th...
You can use below query to achieve this. SELECT employee.*FROM your_table_name AS employeeJOIN your_table_name AS manager ON manager.EMPNO = employe...