Sub Queries [ Uncorrelated Sub Queries ]
A Subquery as the name suggests , is an Inner Query nested or embedded within another SQL Query also called Outer Query. Key Facts about Sub Queries. The Inner Query or the Subquery...
![Sub Queries [ Uncorrelated Sub Queries ]](https://testingpool.com/wp-content/themes/hueman/assets/front/img/thumb-standard-empty.png)
Category: SQL
Views
Understanding Views: To understand views let’s take an e.g. of a mirror from our day to day life. We can see exact replica of ourselves in the mirror i.e. Virtual image. View is a also...
Indexes
Understanding Indexes : To understand what are Indexes, let’s take a very common example of Index at the back of a book. In Book, Index displays the reference page number for each topic.For...
Data Definition Language ( DDL Commands )
What are DDL Commands ?? Data Definition Language ( DDL Commands ) as the name suggests , are used to define and modify the database objects definitions. They are auto – saved or Auto –...
SQL Statements .
What are SQL Statements ?? SQL Statements are basically commands that are used for : Defining the database objects Manipulating the data Controlling the transactions Deciding the access level of the users for database...