Computer-Networks
September 14, 2024Routing
September 15, 2024UPPCL AE 2019
|
Question 6
|
Consider the following relation schema:
Product (id, name, price)
What will be the output of the following SQL code?
SELECT max(price)
FROM Product
WHERE price < (SELECT max(price) FROM Product);
Product (id, name, price)
What will be the output of the following SQL code?
SELECT max(price)
FROM Product
WHERE price < (SELECT max(price) FROM Product);
|
Highest price of a product
|
|
|
Lowest price of a product
|
|
|
Second highest price of a product
|
|
|
Second lowest price of a product
|
Question 6 Explanation:
Second highest price of a product
Correct Answer: C
Question 6 Explanation:
Second highest price of a product
