Maison >base de données >tutoriel mysql >hive union all嵌套使用

hive union all嵌套使用

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBoriginal
2016-06-07 14:57:441654parcourir

不多说了,直接上代码 无 select id from (select a.id from (select 1 as id from duaunion all select 2 as id from dua) a join (select 4 as id from dua) f on a.id =f.idunion all select b.id from (select 1 as id from duaunion all select 2 as id

不多说了,直接上代码
select id from (
	select a.id from 
	(
	select 1 as id from dua
	union all 
	select 2 as id from dua
	) a join 
	(select 4 as id from dua) f on a.id =f.id
union all 
	select b.id from 
	(
	select 1 as id from dua
	union all 
	select 2 as id from dua
	) b join 
	(select 3 as id from dua) e on b.id =e.id
) c
select id from (
select a.id from 
(
select 1 as id from dua
union all 
select 2 as id from dua
union all
select 5 as id from dua
union all 
select 6 as id from dua
) a join 
(
select 4 as id from dua
 union all
select 3 as id from dua
) b on a.id =b.id
) c
Déclaration:
Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn