Syntax – Subquery
SELECT Statement WHERE ColumnName [Comparison Operator] (SELECT Statement / Values)
Results of one Sql query or Sql statement as the input for another Select query, Insert Into query, Insert From query,Update query and Delete query.
You also can use the result of Subquery as a search condition for using in the IN( ) function or EXISTS operator.
Comparison Operator such as =, >, <, >=, <=, LIKE, IN
Below is example for SQL UNION
Table1
Company |
Sales($) |
Website |
Sql | 2500 | sql.com |
C# | 3000 | C#.com |
Asp.net | 2800 | Asp.net.com |
Table2
Sales |
Website |
2900 | sql.com |
3000 | C#.com |
2800 | Asp.net.com |
SQL Subquery Statement
SELECT * FROM TABLE1 WHERE sales in (SELECT Sales FROM TABLE2)
Result
C# | 3000 | C#.com |
Asp.net | 2800 | Asp.net.com |
SELECT * FROM TABLE1 WHERE sales LIKE (SELECT Sales FROM TABLE2 WHERE Sales <2900)>
Result
Asp.net | 2800 | Asp.net.com |
SELECT * FROM TABLE1where sales > (SELECT Sales FROM TABLE2 WHERE Sales <2900)
Result
C# | 3000 | C#.com
|
Comments are closed