Advertisement
JL-ConcepT

Complicated NW Query

Nov 27th, 2014
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1. SELECT        TOP (3) dbo.Products.ProductName, SUM(dbo.[ORDER Details].Quantity * dbo.[ORDER Details].UnitPrice) AS TotalPrice, dbo.Suppliers.CompanyName
  2. FROM            dbo.Products INNER JOIN
  3.                          dbo.[ORDER Details] ON dbo.Products.ProductID = dbo.[ORDER Details].ProductID INNER JOIN
  4.                          dbo.Suppliers ON dbo.Products.SupplierID = dbo.Suppliers.SupplierID
  5. GROUP BY dbo.Products.ProductName, dbo.Suppliers.CompanyName
  6. ORDER BY TotalPrice
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement