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;

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.