빅데이터/SQL1 2024.08.30. sql SELECT * FROM ([Purchasing].[PurchaseOrderHeader])ORDER BY ([VendorID)] SELECT ([ORDERDATE]) FROM ([Purchasing].[PurchaseOrderHeader]) SELECT * FROM [Purchasing].[PurchaseOrderDetail] ORDER BY [SubTotal] DESC TOP 5,UPDATE [ListPrice] FROM [Production].[Product] SELECT [EmployeeID], [VendorID], SUM([TotalDue]) AS TD FROM [Purchasing].[PurchaseOrderHeader] GROUP BY ROLLUP ([EmployeeID], [VendorID.. 2024. 8. 30. 이전 1 다음