Submit My Question - Recent Questions - Recent Answer
Msdn China Tech >> MS-SQL Server >> 疑难问题

满眼含泪跪求一句sql

f表
id name
1 王
2 张
3 王明
4 张飞
5 王明张飞
6 王明张飞每每
.....
怎么写sql才能求出 象王和张的这种最根层
又怎么写才能求出象6这样的最底层
[155 byte] By [wangqingfeng-王宝宝] at [2008-1-9]
«« java 5.0中类似class.newInstanece()转型有警告的问题
»» 帮忙看一下这个求阶乘之和的程序那里错啦~谢谢呦
# 1
等待高人
wangqingfeng-王宝宝 at 2007-10-19 > top of Msdn China Tech,MS-SQL Server,疑难问题...
# 2
关联规律是什么?
hlq8210-影子 at 2007-10-19 > top of Msdn China Tech,MS-SQL Server,疑难问题...
# 3
select *
from f a
where not exists(select 1 from f where DepartMentCode
like a.name+'%' and a.name<>name)
hlq8210-影子 at 2007-10-19 > top of Msdn China Tech,MS-SQL Server,疑难问题...
# 4
select *
from f a
where not exists(select 1 from f where name
like a.name+'%' and a.name<>name)
hlq8210-影子 at 2007-10-19 > top of Msdn China Tech,MS-SQL Server,疑难问题...
MS-SQL Server
疑难问题

MS-SQL Server Hot Topic

MS-SQL Server New Topic

MS-SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified