Fairooz Adams2,704 Points
Unable to solve...
What's the answer here?
In the library database there's a books table with the columns id, title, author, genre and first_published. Find the book with the longest title. Show the title and then the length. Alias the result of the length calculation to be longest_length. Only retrieve the longest book.
Steven Parker160,421 Points
Here's a few generic hints:
- use ORDER BY with DESCending to get the the largest numbers first
- use LIMIT to control how many records to show
- remember to use the alias on the field created by the function
If you're still having trouble, show your complete query code here.