Home > DeveloperSection > Interviews > What is an SQL subquery?

Posted on    August-24-2014 11:53 PM

 MSSQL Server MSSQL Server 
Ratings:
 1 Answer(s)
  718  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Points:3910
Posted on    August-24-2014 12:00 AM

An SQL subquery is a means of querying two or more tables at the same time. The subquery itself is an SQL SELECT statement contained within the WHERE clause of another SQL SELECT statement, and separated by being enclosed in parenthesis. Some subqueries have equivalent SQL join structures, but correlated subqueries cannot be duplicated by a join.


Don't want to miss updates? Please click the below button!

Follow MindStick