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
