select * from studentinfo where LEFT (ltrim(telnostr),3) IN (135,134,136,137,138,139,150,152,151,188,158,159)
select LEFT (ltrim(telnostr),3) from studentinfo WHERE LEFT (ltrim(telnostr),3) IN (135,134,136,137,138,139,150,152,151,188,158,159)
select LEFT(ltrim(telnostr),3) from studentinfo where LEFT(ltrim(telnostr),3) IN (135,134,136,137,138,139,150,152,151,188,158,159)
select LEFT(ltrim(telnostr),3) from studentinfo where LEFT(ltrim(telnostr),3) IN ('135','134','136','137','138','139','150','152','151','188','158','159')
4楼正解,in是跟在where之后,不能写在select内
in 语句要写在where语句后!
select * from studentinfo where LEFT (ltrim(telnostr),3) IN (135,134,136,137,138,139,150,152,151,188,158,159)in应该使用在条件中 不能当作是一个显示的字段
where LEFT (ltrim(telnostr),3) IN (135,134,136,137,138,139,150,152,151,188,158,159)