forum

home / developersection / forums / sub queries in sql server

Sub Queries In sql Server

Anonymous User 1552 03-Dec-2015

I Want to use subQuery in Sql server please help me.

sql server sql sql server 2008 sql server 2012

Updated on 03-Dec-2015

Other

I am a content writter !

03-Dec-2015

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)