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

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

(a) SELECT B0OK_ID, BOOK_TITLE, MAX(PRICE) FROM BOOK_INFORMATION ;

(b) SELECT MAX(PRICE) FROM BOOK_INFORMATION ;

(c) SELECT MAXIMUM( PRICE) FROM BOOK_INFORMATION ;

(d) SELECT PRICE FROM BOOK_ INFORMATION ORDER BY PRICE DESC ;

Consider  this table --

You can understand by seeing this video ---

ANSWER =

(b) =  SELECT MAX(PRICE) FROM BOOK_INFORMATION ;