- 1

what is the proper arrangement

You need the ages of all bears and lions. The first query shows the ages of bears and birds from zoo1, the other shows the ages of lions and crocodiles from zoo2. SELECT age FROM zoo1 WHERE animal IN ('lion', 'crocodile') UNION WHERE animal IN ('bear', 'bird') SELECT age FROM zoo2

1st Oct 2016, 11:47 AM
ANKIT LIMANI
ANKIT LIMANI - avatar
10 odpowiedzi
+ 7
SELECT age FROM zoo1 WHERE animal IN ('bear', 'bird') UNION SELECT age FROM zoo2 WHERE animal IN ('lion', 'crocodile')
25th Jan 2017, 10:52 PM
Mohamed Shahat Ibrahim Kasem
Mohamed Shahat Ibrahim Kasem - avatar
+ 1
SELECT age FROM zoo1 WHERE animal IN ('bear', 'bird') UNION SELECT age FROM zoo2 WHERE animal IN ('lion', 'crocodile')
19th Jul 2017, 4:43 PM
Ayman Abdul Karim Mohammed
0
what is the proper arrangement You need the ages of all bears and lions. The first query shows the ages of bears and birds from zoo1, the other shows the ages of lions and crocodiles from zoo2. SELECT age FROM zoo1 WHERE animal IN ('lion', 'crocodile') UNION WHERE animal IN ('bear', 'bird') SELECT age FROM zoo2
1st Nov 2016, 3:09 PM
Ozim Ndidi Augustina
0
SELECT age FROM zoo1 WHERE animal IN ('bear', 'bird') UNION SELECT age FROM zoo2 WHERE animal IN ('lion', 'crocodile')
14th Feb 2018, 9:14 AM
Mohamed Shahat Ibrahim Kasem
Mohamed Shahat Ibrahim Kasem - avatar
0
please give me correct quastion
5th Dec 2018, 4:12 AM
Nawidullah Haidary
Nawidullah Haidary - avatar
0
+2 SELECT age FROM zoo1 WHERE animal IN ('bear', 'bird') UNION SELECT age FROM zoo2 WHERE animal IN ('lion', 'crocodile')
2nd Apr 2019, 5:32 PM
Tohidul Islam
Tohidul Islam - avatar
0
Select age From zoo1 Where animal In('bear','bird') Union Select age From zoo2 Where animal In('lion','crocodile')
14th May 2020, 11:40 AM
leela Marisetti
leela Marisetti - avatar
0
SELECT age FROM zoo1 WHERE animal IN ('bear', 'bird') UNION SELECT age FROM zoo2 WHERE animal IN ('lion', 'crocodile')
4th Nov 2020, 10:02 AM
mehran sadiq
mehran sadiq - avatar
0
SELECT age FROM zoo1 WHERE animal IN ('bear', 'bird') UNION SELECT age FROM zoo2 WHERE animal IN ('lion', 'crocodile')
19th Mar 2022, 11:32 PM
Carlos Chachalo
- 1
SELECT age FROM zoo1 WHERE animal IN ('bear', 'bird') UNION SELECT age FROM zoo2 WHERE animal IN ('lion', 'crocodile')
9th Apr 2018, 4:25 PM
Mahnoor Shahzad
Mahnoor Shahzad - avatar