Essential Books

Subquery in SELECT clause

suggest change 
SELECT
  Id, 
  FName, 
  LName,
  (SELECT COUNT(*) FROM Cars WHERE Cars.CustomerId = Customers.Id) AS NumberOfCars
FROM Customers
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

Subqueries:
*Subqueries
*Subquery in FROM clause
*Subquery in WHERE clause
*Subquery in SELECT clause
*Correlated Subqueries
*Subqueries in FROM clause
*Filter query results using query on different table
*Subqueries in WHERE clause
*Subqueries in SELECT clause
Table Of Contents