SELECT 子句中的子查詢

Created: November-22, 2018

 placeholderCopySELECT
  Id, 
  FName, 
  LName,
  (SELECT COUNT(*) FROM Cars WHERE Cars.CustomerId = Customers.Id) AS NumberOfCars
FROM Customers