27,580
社区成员
发帖
与我相关
我的任务
分享
select * from TABLE as a where brxz=12 and(select top 1 brxz from TABLE where brxz=2011 and fyxh=a.fyxh and zfbl=a.zfbl and fyxe=a.fyxe and cxbl=a.cxbl)is null
union all
select * from TABLE as a where brxz=2011 and(select top 1 brxz from TABLE where brxz=12 and fyxh=a.fyxh and zfbl=a.zfbl and fyxe=a.fyxe and cxbl=a.cxbl)is null
select min(fyxh) from tb where brxz = 12 or brxz = 2011 gourd by fyxh
CREATE TABLE tb(brxz int,fyxh int, zfbl int, fyxe int ,cxbl int)
go
insert tb SELECT
12 , 26, 20 , 0 , 0 UNION ALL SELECT
2011, 26, 100 , 0 , 0 UNION ALL SELECT
2000, 26, 20 , 0 , 0 UNION ALL SELECT
12 , 27, 20 , 0 , 0 UNION ALL SELECT
2011, 27, 20 , 0 , 0
--DROP TABLE TB
SELECT * FROM TB WHERE
zfbl IN
(SELECT zfbl FROM
(SELECT DISTINCT BRXZ,zfbl FROM TB WHERE brxz = 12 OR brxz = 2011 )AS T
GROUP BY zfbl HAVING COUNT(zfbl)<=1)
brxz fyxh zfbl fyxe cxbl
----------- ----------- ----------- ----------- -----------
2011 26 100 0 0
(所影响的行数为 1 行)
SELECT DISTINCT * FROM Tb
WHERE brxz=12 AND zfb1 NOT IN (SELECT DISTINCT zfb1 FROM Tb WHERE brzx=2011)
UNION
SELECT DISTINCT * FROM Tb
WHERE brxz=2011 AND zfb1 NOT IN (SELECT DISTINCT zfb1 FROM Tb WHERE brzx=12)
-- =========================================
-- -----------t_mac 小编-------------------
--------------------希望有天成为大虾----
-- =========================================
IF OBJECT_ID('tb') IS NOT NULL
DROP TABLE tb
GO
CREATE TABLE tb(brxz int,fyxh int, zfbl int, fyxe int ,cxbl int)
go
insert tb SELECT
12 , 26, 20 , 0 , 0 UNION ALL SELECT
2011, 26, 100 , 0 , 0 UNION ALL SELECT
2000, 26, 20 , 0 , 0 UNION ALL SELECT
12 , 27, 20 , 0 , 0 UNION ALL SELECT
2011, 27, 20 , 0 , 0
go
declare @n1 int ,@n2 int
set @n1=12
set @N2 =2011
select *
from tb k
where (brxz=@N1 and not exists(select * from tb where brxz=@n2 and zfbl=k.zfbl))
or (brxz=@N2 and not exists(select * from tb where brxz=@n1 and zfbl=k.zfbl))
/*
brxz fyxh zfbl fyxe cxbl
----------- ----------- ----------- ----------- -----------
2011 26 100 0 0
*/
go
SELECT DISTINCT BRXZ,zfbl FROM TB WHERE brxz = 12 OR brxz = 2011
SELECT DISTINCT * FROM Tb
WHERE brxz=12 AND brxz<>2011
UNION
SELECT DISTINCT * FROM Tb
WHERE brxz=2011 AND brxz<>12
SELECT DISTINCT(*) FROM TB
WHERE brxz = 12 OR brxz = 2011