从表月份明智地选择数据时出现问题 [英] Problem in select data from table month wise

问题描述

大家好.

从表月份明智地选择数据时出现问题.
我想从我的表中获取数据，该表具有名为date的列.
我想按月和年检索数据，但不按日期检索.
谁能告诉我解决方案.

Hello to all.

Problem in select data from table month wise.
I want to fetch data from my table which has a column named date.
I want to retrieve data by month and year but not with date.
Can any one tell me the solution.
Thanks.

推荐答案

创建一个月的第一天和该月的最后一天的datetime值，然后在带有BETWEEN子句的SQL SELECT语句中使用这些值??

Create a datetime value of the first day of the month and the last day of the month, then use those in a SQL SELECT statement with a BETWEEN clause??

这篇关于从表月份明智地选择数据时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！