Sub Queries In sql Server

Total Post:341

 857  View(s)
Rate this:
I Want to use subQuery in Sql server please help me.
  1. Post:281

    Re: Sub Queries In sql Server

    A Subquery or Inner query or Nested query is a query within another SQL query and embedded within the WHERE clause.

    A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved.

    Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, <, >, >=, <=, IN, BETWEEN etc.

    SELECT * FROM Employee WHERE Emp_ID IN (SELECT Emp_ID FROM Employee WHERE Emp_Sal > 1000)

      Modified On Apr-10-2018 06:18:11 AM