所以,我已经问了一个类似于这个这里的questoin,但是我会再问一次,因为我需要的是类似的,但是有不同的条件。
举个例子,我有一个包含某些数据的Pokemon列,其中很多是重复的
精灵宝可梦
Mega Blastiose
Blastoise
Mega Charizard
Mega Venusaur
Pichu
Pikachu
Alakazam
Pichu
Kadabra
Squirtle
Wartotle
Wartotle
Diglett如果存在同一column上的特定数据,则只需选择特定的数据。在通过pokemon获取数据之前,必须存在SELECT列中的某些数据。
我想要的是一个查询,它可以执行这样的操作,但要对多个数据执行。
SELECT * FROM table
(
If Pichu doesn't exists then don't SELECT Pikachu
If (Abra OR Kadabra) doesn't exists then don't SELECT Kadabra
If (Squirtle OR Wartotle OR Blastoise) doesn't exists then don't SELECT Mega Blastoise
If Pidgety doesn't exists then don't SELECT Pidgeotto
If (Charmarder OR Charmeleon OR Charizard) doesn't exists then don't SELECT Mega Charizard
If (Bulbasaur OR Ivysaur OR Venusaur) doesn't exists then don't SELECT Mega Charizard
)因此,我所需要的SELECT查询的最后结果将产生某种结果。
Mega Blastiose
Blastoise
Pichu
Pikachu
Alakazam
Pichu
Kadabra
Squirtle
Wartotle
Wartotle
Diglett它忽略了,MegaChar火龙和,因为它们是唯一的数据,不符合他们的条件,同时获取其他一切。我知道这有点让人费解,但这是我要找的查询
发布于 2020-02-26 10:23:27
直接:
SELECT pokemons.pokemon
FROM pokemons
LEFT JOIN
( SELECT CASE WHEN SUM(pokemon IN ('Pichu')) = 0
THEN 'Pikachu' END pokemon FROM pokemons -- false
UNION
SELECT CASE WHEN SUM(pokemon IN ('Abra', 'Kadabra')) = 0
THEN 'Kadabra' END FROM pokemons -- false
UNION
SELECT CASE WHEN SUM(pokemon IN ('Squirtle', 'Wartotle', 'Blastoise')) = 0
THEN 'Mega Blastoise' END FROM pokemons -- false
UNION
SELECT CASE WHEN SUM(pokemon IN ('Pidgety')) = 0
THEN 'Pidgeotto' END FROM pokemons -- true, but absent
UNION
SELECT CASE WHEN SUM(pokemon IN ('Charmarder', 'Charmeleon', 'Charizard')) = 0
THEN 'Mega Charizard' END FROM pokemons -- true
UNION
SELECT CASE WHEN SUM(pokemon IN ('Bulbasaur', 'Ivysaur', 'Venusaur')) = 0
THEN 'Mega Charizard' END FROM pokemons -- true, again
) exclude ON pokemons.pokemon = exclude.pokemon
WHERE exclude.pokemon IS NULLhttps://stackoverflow.com/questions/60411475
复制相似问题