Databases Reporting with SQL Working with Text Getting the Length of a String

Ed Sadler
Ed Sadler
11,009 Points

Can someone take a look at my SQL statement. I'm obviously overlooking something.

I keep getting a "recheck your statement" message but I've tried everything. I don't know if my statement is wrong or there's an issue with the program.

Ed Sadler
Ed Sadler
11,009 Points

Yes, sorry.

SELECT title, LENGTH(title) AS longest_length FROM books ORDER BY length DESC LIMIT 1;

1 Answer

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 47,377 Points

LENGTH is a function. You'll want to sort by your alias like this:

SELECT title, LENGTH(title) as longest_length FROM books ORDER BY longest_length DESC LIMIT 1; 
Ed Sadler
Ed Sadler
11,009 Points

That's awesome. Thank you. I don't think I would have figured that one out.