如何筛选不在日期范围内的项目 [英] How To Filter An Item Which Is Not In a Date Range

问题描述

我有一个表格发票，它有Itemcode和saledate列

i想要获得自去年以来未在交易中的项目代码



如何使用sql语句执行此操作

谢谢

I Have a table call Invoice and it has Itemcode and saledate Columns
i want to get itemcodes which are not in transaction since last two year

how to do this using sql statement
Thanks

推荐答案

尝试：

Try:

SELECT ItemCode FROM Invoice
GROUP BY ItemCode
HAVING MAX(SaleDate) < DATEADD(year, -2, GETDATE())

这篇关于如何筛选不在日期范围内的项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！