Question: Consider the following table: Name: table 1 cod 1 val 1 val 2 1 0 1 0 8 1 2 1 0 6 2 1

Consider the following table:
Name: table1
cod1
val1
val2
10
10
8
12
10
6
21
11
15
33
10
2
41
9
11
8
10
6
14
9
5
11
11
4
What is the result of the query below?
SELECT MAX(val2)
FROM table1
WHERE val1 in (SELECT val1
FROM table1
WHERE val2=(SELECT MIN(val2)
FROM table1))

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!