最高价的MSSQL语句 [英] MSSQL statement for Highest Price

问题描述

拖车柱



价格及订购日期







我想编写mssql查询，以便在订单日期列的最后两周从价格列中选择最高价格。

解决方案

  SELECT  MAX（价格） FROM  myTable  WHERE  DateDiff（ww，OrderDate，getDate（））<  2  

有关使用DateDiff的更多信息，请访问此处 [ ^ ]。

尝试：

  SELECT  MAX（价格） FROM  myTable  WHERE  OrderDate  BETWEEN  '  2012-12-12'  AND  '  2012-11-28' 

tow column

Price and Order Date



I would like to write mssql query for selecting highest price from Price Column during last two weeks of Order Date column.

解决方案

SELECT MAX(Price) FROM myTable WHERE DateDiff(ww, OrderDate, getDate()) < 2

More info about the use of DateDiff can be found here[^].

Try:

SELECT MAX(Price) FROM myTable WHERE OrderDate BETWEEN '2012-12-12' AND '2012-11-28'

这篇关于最高价的MSSQL语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！