WHERE (ENROLL_SCHOOL = '300000001530415' AND ENROLL_DEPART IN ('56','59','57','58','60','61','62','63') AND ENROLL_CURRICULUM IN ('54','32','34','33','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53') AND ENRLL_GRADE IN ('175','111','112','101','102','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','103','104','235','236','90','93','91','92','94','95','96','97','98','99','100','105','88','89','106','107','108','109','237','238','239','240','241','242','243','244') AND ENTRLL_TREM = '98')
2条回答 默认 最新
- xiaomad 2018-11-02 05:14关注
ENROLL_DEPART IN ('56','59','57','58','60','61','62','63')
上述一段表示表里ENROLL_DEPART 这列的值可以为'56','59','57','58','60','61','62','63'中的任意一个。
其他类推。解决 无用评论 打赏 举报
悬赏问题
- ¥20 云服务Linux系统TCP-MSS值修改?
- ¥20 怎么在stm32门禁成品上增加记录功能
- ¥15 Source insight编写代码后使用CCS5.2版本import之后,代码跳到注释行里面
- ¥50 NT4.0系统 STOP:0X0000007B
- ¥15 想问一下stata17中这段代码哪里有问题呀
- ¥15 flink cdc无法实时同步mysql数据
- ¥100 有人会搭建GPT-J-6B框架吗?有偿
- ¥15 求差集那个函数有问题,有无佬可以解决
- ¥15 【提问】基于Invest的水源涵养
- ¥20 微信网友居然可以通过vx号找到我绑的手机号