Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 61 of 90

Querying Using SQL — Question 1

Back to all questions
1
Question

Question 1

Table BOOK_INFORMATION

Column Name
BOOK_ID
BOOK_TITLE
PRICE

Which SQL statement allows you to find the highest price from the table BOOK_INFORMATION?

  1. SELECT BOOK_ID, BOOK_TITLE, MAX(PRICE) FROM BOOK_INFORMATION;
  2. SELECT MAX(PRICE) FROM BOOK_INFORMATION;
  3. SELECT MAXIMUM(PRICE) FROM BOOK_INFORMATION;
  4. SELECT PRICE FROM BOOK_INFORMATION ORDER BY PRICE DESC;
Answer 
SELECT MAX(PRICE) FROM BOOK_INFORMATION;
Explanation
  1. SELECT BOOK_ID, BOOK_TITLE, MAX(PRICE) FROM BOOK_INFORMATION; — This query selects the BOOK_ID, BOOK_TITLE, and maximum PRICE from the BOOK_INFORMATION table. However, the requirement is to find the highest price only.
  2. SELECT MAX(PRICE) FROM BOOK_INFORMATION; — This query selects the maximum PRICE from the BOOK_INFORMATION table using the MAX() aggregate function. This option is correct because it directly retrieves the highest price among all the books listed in the BOOK_INFORMATION table, which is what the question asks for.
  3. SELECT MAXIMUM(PRICE) FROM BOOK_INFORMATION; — There is no MAXIMUM() function in SQL.
  4. SELECT PRICE FROM BOOK_INFORMATION ORDER BY PRICE DESC; — This query selects all prices from the BOOK_INFORMATION table and orders them in descending order using ORDER BY PRICE DESC but it doesn't directly give the highest price.