• SQL Inline View:It is used as a SELECT statement in the form clause.
  
  Syntax:
  

          SELECT "column_name" FROM (Inline View);
          

  Example: Two tables customer and score having a common field i.e. cust_id

SQL_Advance:SQL Inline View

• SQL INTERSECT:It is similar to union and used for combining SQL Statement.
  
  Syntax:
  

          [SQL Statement 1]
  
           INTERSECT
  
           [SQL Statement 2];
  
          

  Example: Two tables customer's_detail and customer's_income having a common field i.e. date_of-joining and two different fields

     SELECT `date_of-joining` FROM `customer's_detail`

      INTERSECT

      SELECT `date_of-joining` FROM `customer's_income`

   

• SQL MINUS:It is used for getting the different value two different tables.
  
  Syntax:
  

       [SQL Statement 1]
  
       MINUS
  
       [SQL Statement 2];
       

  Example: Two tables customer and score having a common field i.e. cust_id

  SELECT `date_of-joining` FROM `customer's_detail`

      MINUS

      SELECT `date_of-joining` FROM `customer's_income`

     

• SQL LIMIT:SQL LIMIT is used for limiting the result..
  
  Syntax:
  

         [SQL Statement 1]
  
           LIMIT [N];
  
          

  Example: Two tables customer's_detail and customer's_income having a common field i.e. date_of-joining and two different fields

SQL_Advance:SQL LIMIT