Which of the following SELECT statements lists only the book with the largest profit?
a. SELECT title, MAX(retail-cost)
FROM books
GROUP BY title;
b. SELECT title, MAX(retail-cost)
GROUP BY title
HAVING MAX(retail-cost);
c. SELECT title, MAX(retail-cost)
FROM books;
d. none of the above
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here