为什么我的查询仅显示一个结果? [英] Why is only one result showing from my query?

问题描述

为什么我从下面的查询中只得到一个结果?建议的答案"的名字叫苏珊"，而不是我在搜索结果中得到的名字.

Why am I only getting one result from the query below? The suggested "answer" has the first name "Susan" instead of what I got in my results.

SELECT EmpFirstName, EmpLastName, p.ProductName as ProductName, 
YEAR(c.OrderDate) AS Year, 
SUM(o.QuotedPrice + o.QuantityOrdered) AS TotalValue 
FROM Employees 
NATURAL JOIN Products p 
NATURAL JOIN Order_Details o 
NATURAL JOIN Orders c 
ORDER BY Year, TotalValue DESC

结果图片

表结构的图像

推荐答案

因为您的查询中存在总和

Because there are a Sum in your Query

这篇关于为什么我的查询仅显示一个结果?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！