Question

Consider the below table:
Products Table
Column Name Datatype Constraint
Prod_id Number PK
Prod name Varchar
Prod_list price Varchar
Cusl credit limit Number

What would be the outcome of executing the below SQL statement?
select prod name from products where prod_id in
select prod_id from products where prod_list_price=(
select max(prod list price) from products where prod_list_price<(
select max(prod list price) from products)));
Select one:
1. It shows the names of all products in the table.
2. It produces an error
3. It shown the names of all products whose list price is less than the maximum list price
4. It shown the names of products whose list price is the second highest in the table​

Answer 1

Answer:

the correct answer for this question is 3

Answer 2

Answer:

4. It shown the names of products whose list price is the second highest in the table.

Explanation: