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.

Thank you for reading this post, don't forget to subscribe!

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

 

Show 2 Comments

2 Comments

No comments yet. Why don’t you start the discussion?

Comments are closed