求助:有关数据查询问题 select a.* from 表 a,表 b where a.sage=b.sage and a.saddress=b.saddress 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select t.Sname from S t where exists(select 1 from S where Sage=t.Sage and Saddress=t.Saddress and Sname!=t.Sname) select sname from S as awhere exists( select Sage,Saddress from S where Sage=a.Sage and Saddress=a.Sage group by Sage,Saddress having count(1)>1 ) 从字符串转换为 datetime 时发生语法错误。 访问数据库问题 SQL高手请进 sql 两表之间的查询 sql连续数合并问题 sql多表关联取某表的抽出记录数(急) 有关排序规则的问题 SQL Server 2000 有什么快捷的方法写数据字典 有关视图的问题,在线等。 求助SQL语句:在一张单位员工表里,请检索出所有出生年月日相同的员工! SQL2000中右键点设计报ODBC错误~~急,在线等!!!!
t.Sname
from
S t
where
exists(select
1
from
S
where
Sage=t.Sage
and
Saddress=t.Saddress
and
Sname!=t.Sname)
where exists(
select Sage,Saddress from S
where Sage=a.Sage and Saddress=a.Sage
group by Sage,Saddress
having count(1)>1
)