if (select count(*) from (select b,c from A group by b,c having count(*)=2))>0
begin
select max(A.a) from A join (select b,c from A group by b,c having count(*)=2) AS B where A.b=B.b and A.c=B.c
END
begin
select max(A.a) from A join (select b,c from A group by b,c having count(*)=2) AS B where A.b=B.b and A.c=B.c
END
解决方案 »
- 关于插入的问题
- #1064 - You have an error in your SQL syntax; check the manual that corresponds
- sql server 2005 本地发布和订阅报错
- 请教如何查询是哪2个查询或存储过程导致的死锁,谢谢
- 如何建表时设置getdate()默认值列
- 一个简单的查询语句
- 求一查询语句
- 时间差防止冲突解决办法
- 非服务器的pc想attach一个数据库文件,被提示数据库文件必须限制在2G以内,如何解决,文件有3G
- SQL Server中好像默认是不区分大小写的,怎么设置成区分大小写?
- 如何知道某条记录在数据表里的绝对位置?
- sql200 sp3a有三个文件,请问延安装时,要分先后吗?
if (select count(*) from (select b,c from A group by b,c having count(*)=2))>0
begin
select max(A.a) from A , (select b,c from A group by b,c having count(*)=2) AS B where A.b=B.b and A.c=B.c
END
f1 nvarchar(20),
f2 nvarchar(20),
f3 nvarchar(20),
f4 nvarchar(20)
)insert into #Table1(f1,f2,f3,f4)
values('1','2','3','4')
insert into #Table1(f1,f2,f3,f4)
values('2','2','3','4')
insert into #Table1(f1,f2,f3,f4)
values('3','1','3','4')
insert into #Table1(f1,f2,f3,f4)
values('4','1','3','4')select t1.* from #table1 t1 right join
( select f1 = max(f1), f2, f3--, f4
from #Table1
group by f2, f3) t2 on t1.f1 = t2.f1 and t1.f2 = t2.f2 and t1.f3 = t2.f3drop table #Table1
on a.a=b.a