In this short post, I would like to introduce the concept of subqueries in SQL.
In SQL the principle is identical.
Web development, web design and programming.
Showing posts with label subquery. Show all posts
Showing posts with label subquery. Show all posts
Thursday, 24 January 2013
SQL: subqueries
Tweet
In this short post, I would like to introduce the concept of subqueries in SQL.
A subquery is a query statement inside another query statement. As you already know the order in which a statement is processed is quite important. That is a basic rule like in maths: writing something like 2+2*5 is different than writing (2+2)*5. The first operation gives 12, the second 20.
In SQL the principle is identical.
In this short post, I would like to introduce the concept of subqueries in SQL.
In SQL the principle is identical.
Subscribe to:
Posts (Atom)