2000 也是支持的,是不是gid 不是字符类型啊? 如果是 请改: select * from t_grp_org where CHARINDEX(cast(gid as varchar(20)),nodepath,0)>0
SELECT a.* FROM TB a,TB b WHERE a.a列 LIKE '%' +b.b列+'%'
报charindex标示符无效,什么意思啊
改一下表名 SELECT a.* FROM abc a , abc b WHERE a.a LIKE '%' + B.b + '%'
create table T_GRP_ORG ( GID NUMBER not null, GNAME VARCHAR2(255) not null, ORGABBR VARCHAR2(255) not null, ORGSPELL VARCHAR2(255), SUPID NUMBER not null, LEVELS NUMBER not null, NODEPATH VARCHAR2(255), DESCRIPTION VARCHAR2(400), CONTACT VARCHAR2(255), PHONE VARCHAR2(64), UNMALLOCEDIPSETFLAG VARCHAR2(1) default 0 )
不是mysql,下班,回去没人回复我再回复
oracle啊,大神们,我不是做sql的,做java的,这sql搞死我了,各路大神救救急
怎么发mssql里了 南辕北辙啊 兄弟
select a, b from abc where a like ('%' || b || '%') ---------------------------------------------- select ORGABBR, ORGSPELL from T_GRP_ORG where ORGABBR like ('%' || ORGSPELL || '%')
select * from abc where CHARINDEX(b,a,0)>0
FROM abc
WHERE a LIKE '%' + ( SELECT b
FROM abc
) + '%'
select * from abc where CHARINDEX(b,a,0)>0 括号里的0是什么意思啊
select * from t_grp_org where CHARINDEX(gid,nodepath,0)>0
select * from t_grp_org where nodepath like '%'+(select gid from t_grp_org)+'%'
如果是 请改:
select * from t_grp_org where CHARINDEX(cast(gid as varchar(20)),nodepath,0)>0
FROM TB a,TB b
WHERE a.a列 LIKE '%' +b.b列+'%'
SELECT a.*
FROM abc a ,
abc b
WHERE a.a LIKE '%' + B.b + '%'
(
GID NUMBER not null,
GNAME VARCHAR2(255) not null,
ORGABBR VARCHAR2(255) not null,
ORGSPELL VARCHAR2(255),
SUPID NUMBER not null,
LEVELS NUMBER not null,
NODEPATH VARCHAR2(255),
DESCRIPTION VARCHAR2(400),
CONTACT VARCHAR2(255),
PHONE VARCHAR2(64),
UNMALLOCEDIPSETFLAG VARCHAR2(1) default 0
)
from abc
where a like ('%' || b || '%')
----------------------------------------------
select ORGABBR, ORGSPELL
from T_GRP_ORG
where ORGABBR like ('%' || ORGSPELL || '%')