本文介绍了在mssql中按'或'和'和'运算符在同一列上过滤行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一张表有两个字段,比如ad_id和tag。我想通过AND运算符根据标记字段过滤值。 ad_id标签 1诺基亚 2 samsung 1 windows 在这里,我想找出具有标签价值nokia或samsung但只有windows的值。
解决方案选择 *来自 table 其中 tag = ' nokia' 或 tag = ' 三星';
参考: AND vs 或 www.w3schools/sql/sql_and_or.asp [ ^ ]
怎么样。 select * From table where 标记 in (' nokia',' samsung',' samsung')
HI, 尝试这个 DECLARE @ TEMPTB 表( ID INT IDENTITY ( 1 , 1 ),BRAND VARCHAR ( 50 ),OS VARCHAR ( 15 ),NETWORK VARCHAR ( 20 )) INSERT INTO @ TEMPTB (品牌,操作系统,网络) SELECT ' NOKIA',' WINDOWS',' 2G' UNION ALL SELECT ' SAMSUNG', ' WINDOWS',' 2G' UNION ALL SELECT ' SAMSUNG',' ANROID ',' 3G' UNION ALL SELECT ' HTC',' WINDOWS',' 3G' UNION ALL SELECT ' NOKIA',' ANROID',' 2G' SELECT * FROM @ TEMPTB SELECT * FROM @ TEMPTB WHERE OS = WINDOWS' AND (BRAND = ' NOKIA' OR BRAND = ' SAMSUNG' OR BRAND = ' HTC') AND (NETWORK = ' 2G' 或 NETWORK = ' 3G')
I have a table having two fields say ad_id and tag. I want to filter values on the basis of tag field by AND operator. ad_id tag 1 nokia 2 samsung 1 windows Here I want to find out values having tag value nokia or samsung but only windows.
解决方案 select *From table where tag ='nokia' or tag = 'samsung' ;refer this : AND vs OR www.w3schools/sql/sql_and_or.asp[^]
how about this. select * From table where tag in ('nokia','samsung','samsung')HI, TRY LIKE THIS DECLARE @TEMPTB TABLE( ID INT IDENTITY(1,1) ,BRAND VARCHAR(50) ,OS VARCHAR(15) ,NETWORK VARCHAR(20) ) INSERT INTO @TEMPTB (BRAND,OS,NETWORK ) SELECT 'NOKIA','WINDOWS','2G' UNION ALL SELECT 'SAMSUNG','WINDOWS','2G' UNION ALL SELECT 'SAMSUNG','ANROID','3G' UNION ALL SELECT 'HTC','WINDOWS','3G' UNION ALL SELECT 'NOKIA','ANROID','2G' SELECT * FROM @TEMPTB SELECT * FROM @TEMPTB WHERE OS ='WINDOWS' AND (BRAND = 'NOKIA' OR BRAND='SAMSUNG' OR BRAND='HTC') AND (NETWORK='2G' OR NETWORK = '3G')更多推荐
在mssql中按'或'和'和'运算符在同一列上过滤行
发布评论