SQL Server 按日期获取最新值

# 获取 SQL Server 中按日期获取最新值的方法

sql
CREATE TABLE StockPrices (
    Date DATE,
    Price DECIMAL(10, 2)
);

sql
INSERT INTO StockPrices (Date, Price) VALUES
('2023-01-01', 100.00),
('2023-01-02', 105.50),
('2023-01-03', 98.75),
('2023-01-04', 102.20),
('2023-01-05', 110.50);

sql
SELECT Date, MAX(Price) AS LatestPrice
FROM StockPrices
GROUP BY Date;

sql
SELECT Date, Price
FROM (
    SELECT 
        Date,
        Price,
        ROW_NUMBER() OVER (PARTITION BY Date ORDER BY Date DESC) AS RowNum
    FROM StockPrices
) AS Ranked
WHERE RowNum = 1;