[英翻中] 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年的訂單

👍 0 👎 0

收錄日期: 2021-04-30 21:53:07
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20160908105423AARtZfL

檢視 Wayback Machine 備份