What is the result of the query below? SELECT * FROM table1 WHERE val1 IN (SELECT vall FROM table1 WHERE val2 = (SELECT MAX(val2) FROM table 1));

icon
Related questions
Question
100%
Need a step by step of how to solve this. Thank you!
Name: table1
codl
10
12
21
33
41
8
14
11
vall
10
10
11
10
9
10
9
11
val2
8
2
6
4
6
15
11
AR
Transcribed Image Text:Name: table1 codl 10 12 21 33 41 8 14 11 vall 10 10 11 10 9 10 9 11 val2 8 2 6 4 6 15 11 AR
What is the result of the query below?
SELECT *
FROM table1
WHERE vall IN (SELECT vall
FROM tablel
WHERE val2 = (SELECT MAX(val2)
FROM table1));
Transcribed Image Text:What is the result of the query below? SELECT * FROM table1 WHERE vall IN (SELECT vall FROM tablel WHERE val2 = (SELECT MAX(val2) FROM table1));
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer