Subqueries

Question 1

Can you have an order by in a subquery?

Answer 1

Only if TOP is also specified

Question 2

Where can you put a subquery?

Answer 2

In the select clause (as a column), as a joined table (inline query, derived table), or in the where clause.

Question 3

What is the difference between a subquery and a correlated subquery

Answer 3

A correlated subquery references the main query