Description:
Here i will explain how to create subquery in sql server with example and syntax.
What is subquery in sql?
In SQL Server, a subquery is a query within a query. You can create subqueries within your SQL statements. These subqueries can reside in the "WHERE" clause, the "FROM" clause, or the "SELECT" clause.
Syntax:
Example:
Here i will explain how to create subquery in sql server with example and syntax.
What is subquery in sql?
In SQL Server, a subquery is a query within a query. You can create subqueries within your SQL statements. These subqueries can reside in the "WHERE" clause, the "FROM" clause, or the "SELECT" clause.
Syntax:
SELECT [ColumnName] FROM [TableName]
WHERE [ColumnName] in (SELECT [ColumnName]FROM [TableName])
Example:
SELECT ItemName FROM tblItem
WHERE ItemName in (SELECT ItemName FROM tblOrder)
In above example, we get those ItemName whis is available in
tblOrder table. We can also use subquery in "SELECT" and "FROM" clause.
No comments:
Post a Comment