一个sql问题,请大家帮忙

2007-11-30 10:07:13 144 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

79.ScottPlot的MVVM实现 C#例子 WPF例子在你的 WPF 窗口的 XAML 文件中，定义一个，并将其Content属性绑定到 ViewModel 中的属性。这样可以将WpfPlot控件动态绑定到 ViewModel。阅读详情

有两张表，a，b
a的结构如下
ck int *
lb int *
bh int *
gg int *
mm char
nn int
b的结构如下
ck int *
lb int *
bh int *
gg int *
dd int
a,b表中带*号的为主键
想得到 a表中存在而b表中不存在的记录，对于多个主键不知道各位有没有好的办法？

现送100分，不够再给。。。。
着急着呢。。。。。

...全文

数据可视化—power bi 基础操作汇总数据来源: https://pan.baidu.com/s/1U_Y7rKfhnSKbLmh4FcUD_Q 提取码: yq5v 目录基本功能与视图编辑与查询—修改column案例建立关联性新增column与DAX完成总价运算习题练习1:建立可视化图表产品销售统计图 column拖曳可视化 1.基本功能与视图 ①基础操作界面 ②获取数据—以打开excel为例 ③数据文件基本视图可视化形式:柱状图、数据、关联性 2.编辑与查询—修改column ①编辑与查询—数据处理界面 . 阅读详情

rishengw

应用实例 27,579 成员 68,540 内容

+ 关注 + 加入社区

切换为时间正序

昵称被占用了 2007-11-30

打赏
举报

结贴有点太快了

liyanmingkong 2007-11-30

打赏
举报

想问一下，鸟同志的方法为什么不对啊？？

昵称被占用了 2007-11-30

打赏
举报

鸟的方法是不错的，效率不低，只是select的结果需要改下



select a.*

from a left join b

on a.ck=b.ck and a.lb=b.lb and a.bh=b.bh and a.gg=b.gg

where b.ck is null

rishengw 2007-11-30

打赏
举报

海阔天空跟老乌龟的方法ok
谢谢大家

rishengw 2007-11-30

打赏
举报

鸟同志的方法不对

dawugui 2007-11-30

打赏
举报

--相同

select a.* , b.* from a,b where a.ck = b.ck and a.lb = b.lb and a.bh = b.bh and a.gg = b.gg



--不同

--效率高

select a.* from where not exists(select 1 from b where ck = a.ck and lb = a.lb and bh = a.bh and gg = a.gg)

--效率不高

select a.* from a where cast(ck as varchar) + ',' + cast(lb as varchar) + ',' + cast(bh as varchar) + ',' cast(gg as varchar) not in (select cast(ck as varchar) + ',' + cast(lb as varchar) + ',' + cast(bh as varchar) + ',' cast(gg as varchar) from b)

fwacky 2007-11-30

打赏
举报



create table rishengwA

(

   ck   int     ,

    lb   int     ,

    bh   int    ,

    gg   int    ,

    mm   char ,

    nn   int 

primary key(ck,lb,bh,gg)

)

create table rishengwB

(

    ck   int   ,

    lb   int    ,

    bh   int   , 

    gg   int   ,

    dd   int 

primary key(ck,lb,bh,gg)

)



delete rishengwA

insert into rishengwA

select 1,2,3,4,'A',8 union all 

select 1,2,3,5,'A',9 union all 

select 1,2,3,6,'A',10 union all 

select 1,2,3,7,'A',11 union all 

select 1,2,3,8,'A',12 union all 

select 1,2,3,9,'A',13 



delete rishengwB

insert into rishengwB

select 1,2,3,4,8 union all 

select 1,2,3,5,9 union all 

select 1,2,3,6,10 



select rishengwA.*

 from rishengwA   where  cast(ck as varchar(10)) +cast(lb as varchar(10))+cast(bh as varchar(10))+cast(gg as varchar(10))  not in 

  (select cast(ck as varchar(10)) +cast(lb as varchar(10))+cast(bh as varchar(10))+cast(gg as varchar(10)) as id from rishengwB)



===========================

1	2	3	7	A	11

1	2	3	8	A	12

1	2	3	9	A	13

leo_lesley 2007-11-30

打赏
举报

鸟的方法好,不过楼主这也太浪费分了吧!

dawugui 2007-11-30

打赏
举报

select a.* from a where cast(ck as varchar) + ',' + cast(lb as varchar) + ',' + cast(bh as varchar) + ',' cast(gg as varchar) not in (select cast(ck as varchar) + ',' + cast(lb as varchar) + ',' + cast(bh as varchar) + ',' cast(gg as varchar) from b)

昵称被占用了 2007-11-30

打赏
举报

a表中存在而b表中不存在的记录:



select * from a

where not exists (

select 1 from b

where ck=a.ck and

    lb=a.lb and

    bh=a.bh and

    gg=a.gg

)

chuifengde 2007-11-30

打赏
举报

select *

from a left join b

on a.ck=b.ck and a.lb=b.lb and a.bh=b.bh and a.gg=b.gg

where b.ck is null

一个sql问题,请大家帮忙

相关推荐