[英翻中] Filter the results to group only the rows with an order year 2008. (完整句子在詳細資料中)?
2016-09-08 6:54 pm
Write a SELECT statement against the Sales.Orders and Sales.OrderDetails tables, and display the empid column and a calculated column representing the total sales amount. Filter the results to group only the rows with an order year 2008.
回答 (1)
2016-09-09 12:45 am
✔ 最佳答案
針對銷售，訂單與銷售，銷售詳情三方面寫一個SELECT程式語句，要有兩列能分別顯示員工編號和計算銷售總數。篩選結果，使其只顯示2008年的訂單
收錄日期: 2021-04-30 21:53:07
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20160908105423AARtZfL