在一个语句中多个BETWEEN和AND [英] Multiple BETWEEN and AND in one statement

问题描述

在我的桌子上我有



年份和月份

2014 02

有一个选项可供选择用户选择日期范围



所以当我尝试选择



我使用这种语法：



从dbo.User中选择*在'2014'和'02'以及'2014'和'03'之间的年份和月份



我没有IDEA如何解决这个问题。请帮助

In my table I have

YEAR and MONTH
2014 02
There is an option for the users to select date ranges

so when I try to select

I use this syntax:

Select * from dbo.User where YEAR and MONTH between '2014' and '02' and '2014' and '03'

I have no IDEA how to acieve this. help please

推荐答案

Select * from dbo.User where YEAR = '2014' and MONTH IN ('02','03')

了解详情： sql_where [ ^ ]

这篇关于在一个语句中多个BETWEEN和AND的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！