n my previous articles I have given the idea about the different Business intelligence concepts.. This article will give you information about Data Mart vs…View More What is difference between data mart and data warehouse?
Oracle 11g vs 12c : In my previous article, I have given the idea about the Oracle 11g new features. There are some newly added…View More Oracle 11g vs 12c | What is Difference between Oracle 11G and Oracle 12c
NoSQL vs SQL : From last 5 years the total data in the world is tripled and data is growing so rapidly.In this world of…View More What is Difference between SQL and NoSQL | NoSQL vs SQL
Difference between delete truncate and drop in sql : In previous articles i have explained about difference between views and complex-views,difference between set operators.In This…View More What is Difference between delete truncate and drop in sql | Truncate Delete Drop
Subquery : Subquery is query within query.The output of outer query is assigned to the column which is used in where condition of outer query.The…View More What is difference between subquery and correlated subquery with example?
In my previous articles I have given the different SQL tutorials. In this article I would like to explain about difference between Rank and dense_rank…View More What is difference between Rank and dense_rank function in SQL?
Intersect and Minus in SQL : SQL Set Operators combines the result of 2 queries or components on to the single result. The queries containing…View More What are SQL Set Operators?| Intersect and Minus in SQL
SQL Set Operators combines the result of 2 queries or components on to the single result. The queries containing the different set operators like union,…View More What is difference between Union and Union all with examples?
Materialized views in SQL : In this article, I will give the basic information about What exactly the Materialized views in SQL. View are nothing…View More What is Materialized views in SQL | Materialized view example
Difference between simple view and complex view: Views in SQL is nothing but the logical table created from one or more tables. We can use…View More What is Difference between simple view and complex view with example?