...
Computer-Networks
September 14, 2024
Routing
September 15, 2024
Computer-Networks
September 14, 2024
Routing
September 15, 2024

UPPCL 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);
A
Highest price of a product
B
Lowest price of a product
C
Second highest price of a product
D
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

Leave a Reply

Your email address will not be published. Required fields are marked *