Computer Science
Related Questions
What are aggregate functions? What is their use? Give some examples.
What type of functions can you use with GROUP BY and HAVING clauses ?
What are most common types of SQL joins ?
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?
- SELECT BOOK_ID, BOOK_TITLE, MAX(PRICE) FROM BOOK_INFORMATION;
- SELECT MAX(PRICE) FROM BOOK_INFORMATION;
- SELECT MAXIMUM(PRICE) FROM BOOK_INFORMATION;
- SELECT PRICE FROM BOOK_INFORMATION ORDER BY PRICE DESC;