谁帮我想想这个sql语句怎么写

[铁塔埃菲尔]

假如 select name from t where name= 'xiaoming' 没有一条符合条件的记录 我怎么在sql里 name字段显示 “无符合”

[我姓区不姓区]

if(exists(select 1 from t where name= 'xiaoming' ))
    select * from t where name= 'xiaoming' 
else
    select '无符合'

[ccg_2008]

顶

[xingfeng123]

select distinct(case when name<>'经理'then'无符合' else name end) as name
from t

[blackwolves]

select distinct case when name='xiaoming' then name else '无符合' end from t

[xiangxiao_bobo]

case end 结构

[XiaoShe8]

select name from t where name='xiongming'..

[wangwfksyc]

用T-SQL编程语句

[kingcsx666]

if(exists(select 1 from t where name= 'xiaoming' ))
    select Name from t where name= 'xiaoming' 
else
    select '无符合' As Name

[xiaoyuchen3v]

8L

[qldsrx]

虽然回复了很多，但都写得不够好。这是最简单的SQL写法：

select ISNULL(MAX(name),'无符合') from  t  where name= 'xiaoming'

[薇薇]

我也来学习学习啦
还是可以的哈 不错的哈

[shighui]

select isnull(name,'无符合'） from t where name= 'xiaoming'

[cyp798752401]

O(∩_∩)O~ 刚学 sql 过来学习学习

[百事洞明]

if(exists(select 1 from t where name= 'xiaoming' ))
select * from t where name= 'xiaoming'
else
select '无符合'

[Wude_S]

把name的默认值设成“无符合”，无符合条件的不修改

[皮皮虾向前冲]

推荐给你去看看：http://hi.csdn.net/space-3834954-do-thread-id-3068.html

[hujun1024]

select
(case when
(select count(name) from t where name= 'xiaoming') = 0 then '无符合'
else name
end
) name from t where name = 'xiaoming'

[zhoujk]

有必须做得这么复杂吗

[特别]

要是楼主用的不是Sql server数据库，上面的全部熄火，嘿嘿

[特别]

看来SQL SERVER数据库还是挺火的