sql select inside select sub query

Solutions on MaxInterview for sql select inside select sub query by the best coders in the world

showing results for - "sql select inside select sub query"
Aarón
17 Oct 2016
1SELECT CompanyName, 
2       ProductCount = (SELECT COUNT(P.id)
3                         FROM [Product] P
4                        WHERE P.SupplierId = S.Id)
5  FROM Supplier S
similar questions
queries leading to this page
sql select inside select sub query