sql - 如何在sql中查找只有年份的数据
问题描述
我试图从有两个条件的表中找到计数。
SELECT COUNT(orderID) AS TotalCount
FROM lineitem
WHERE mode = 'AIR'
AND year(shipdate) = '1998';
我的问题是因为“shipdate”列的数据类型是 DATE,我收到错误“无效标识符”
如何解决?谢谢!
解决方案
利用extract
extract(YEAR from shipdate)
推荐阅读
- java - 如何将spring批处理与oracle数据库连接以保存文件内容
- python - 与 Airflow 一起使用时无法识别模块 smb
- spring-boot - 为什么 pom.xml 文件给出未知错误
- html - 如何在角度应用程序中打开其他网站
- python - Using inherited variables in subclass's method on their default arguments
- ruby-on-rails - Create a deep nested hash using loops in Ruby
- javascript - 如何在下拉列表中实现条件语句?
- python - error while using np.meshgrid to plot a 3d-plot because of loops
- django - How to fetch data from one model and display it in the form as drop down for storing it in another model in django
- android - How do I test this Custom UI Class to have code coverage