SQL union而不是in子句 [英] SQL union and not in clause

问题描述

我有桌子

I have table

CREATE TABLE supportContacts 
	(
     id int auto_increment primary key, 
     type varchar(20), 
     details varchar(30),
      code_id int
    );

INSERT INTO supportContacts
(type, details,code_id)
VALUES
('Email0', '[e-mail]',1033),
('Email1', '[e-mail]',1031),
('Email2', '[e-mail]',1033),
('Email3', '[e-mail]',1031),
('Email5', '[e-mail]',1032),
('Email6', '[e-mail]',1032),
('Twitter4', '4@sqlfiddle',1033);

当我运行此查询时

when i ran this query

Select type from supportContacts where code_id=1033
union 
(
  Select type from supportContacts where code_id
  not in (Select type from supportContacts where code_id=1033)
)

输出是

TYPE

Email0

Email2

Twitter4

Email1

Email3

电子邮件5

电子邮件6



我想用join替换这个查询我该怎么做。



谢谢

output is
TYPE
Email0
Email2
Twitter4
Email1
Email3
Email5
Email6

I want to replace this query with join's how can i do that.

Thanks

推荐答案

我得到的回答没有任何加入

最后我想要的在联合条款之前按照查询的顺序出现的数据

所以我只使用订单时和当



从supportContacts中选择类型

命令由

case当code_id = 1033然后1 end desc



请建议我错了....

i got d answer without any join
finally what i want data which comes as per d order of "query" before union clause
so i just use order by and when

Select type from supportContacts
order by
case when code_id=1033 then 1 end desc

please suggest is i m wrong....

这篇关于SQL union而不是in子句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！