| SQLTutorials | |
| Powered By PhICK1.com | |
SQL SubquerySyntax - SubquerySELECT 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
SQL Subquery Statement SELECT * FROM TABLE1 WHERE sales in (SELECT Sales FROM TABLE2) Result
SELECT * FROM TABLE1 WHERE sales LIKE (SELECT Sales FROM TABLE2 WHERE Sales <2900)> Result
SELECT * FROM TABLE1where sales > (SELECT Sales FROM TABLE2 WHERE Sales <2900) Result
powered by www.pHick1.com |
|