SQL MAX和求和功能 [英] SQL MAX and SUM FUNCTION

问题描述

您好，希望您能帮助我！

我有一个名为StockTable的表

股票名称|股票价格| StockDate

DOW 23 01/01/10
RSDB 15 01/01/10
陶氏22 02/01/10
RSDB 11年2月1日
陶氏24 03/01/10
RSDB 12年3月1日
陶氏25年10月4日01
RSDB 16 04/01/10

我需要通过以下SQL获取的每个StockName的最新日期，分别为stockDate:

选择StockName，StockPrice，StockDate
从StockTable
在哪里(StockDate =(SELECT MAX(StockDate)
从StockTable))


返回该表的最新日期为04/01/10


股票名称|股票价格| StockDate


陶氏25年10月4日01
RSDB 16 04/01/10


接下来的部分是我正在努力的部分

我需要在同一条sql语句中获取StockPrice的总和以返回

|股票价格|

41


希望您能帮助我，如果您需要任何澄清，请询问！

感谢

Hi there hope you can help me!

I have the following table named StockTable

StockName|StockPrice | StockDate

DOW 23 01/01/10
RSDB 15 01/01/10
DOW 22 02/01/10
RSDB 11 02/01/10
DOW 24 03/01/10
RSDB 12 03/01/10
DOW 25 04/01/10
RSDB 16 04/01/10

I need to get the latest row by stockDate for each StockName which i have achieved with the following SQL:

SELECT StockName, StockPrice, StockDate
FROM StockTable
WHERE (StockDate = (SELECT MAX(StockDate)
FROM StockTable))


Which returns this table as the most recent date is 04/01/10


StockName|StockPrice | StockDate


DOW 25 04/01/10
RSDB 16 04/01/10


This next bit is the part i am struggling with

i need to get the sum of the StockPrice within the same sql statment to return

|StockPrice|

41


Hope you can help me and if you need any clarification then please ask!

Thanks

推荐答案

您当前的查询:

Your current query:

SELECT StockName, StockPrice, StockDate
FROM StockTable
WHERE (StockDate = (SELECT MAX(StockDate)
FROM StockTable))

新查询:

New query:

SELECT SUM(StockPrice) as StockPriceSum
FROM StockTable
WHERE (StockDate = (SELECT MAX(StockDate)
FROM StockTable)) 

结果将是SUM.例如. 41这里.

Result of it would be the SUM. E.g. 41 here.

行之有效的!!!！

你是救生员！！！

THanks that works great!!!!

you are a life saver!!!

这篇关于SQL MAX和求和功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！