现有layer表如下:
测试数据如下:
CREATE TABLE [Layer] (
[Code] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Name] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_Layer] PRIMARY KEY CLUSTERED
(
[Code]
) ON [PRIMARY]
) ON [PRIMARY]
GOINSERT INTO Layer(Code,[Name])
select 1,'a' union
select 2,'b' union
select 11,'c'
现希望得到如下结果:
Code Name
------ ------ -------
1 a 是
11 c 否
2 b 否小弟新学~~望各位大大帮忙啊~~
测试数据如下:
CREATE TABLE [Layer] (
[Code] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Name] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_Layer] PRIMARY KEY CLUSTERED
(
[Code]
) ON [PRIMARY]
) ON [PRIMARY]
GOINSERT INTO Layer(Code,[Name])
select 1,'a' union
select 2,'b' union
select 11,'c'
现希望得到如下结果:
Code Name
------ ------ -------
1 a 是
11 c 否
2 b 否小弟新学~~望各位大大帮忙啊~~
select *,(case when code = 1 then '是' else '否' end) result from layer这样?
-- try:select *,case when exists(select 1 from layer b where b.code like a.code+'%' and a.code<>b.code) then '是'else '否' end from layer a