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

Siraj Khan
Siraj Khan
3,451 Points

Can anyone please help me with this challenge.?

Can anyone please help me with this challenge.? SELECT title, LENGTH(title) AS longest_length FROM books ORDER BY length DESC LIMIT 1;

1 Answer

Tareq Alothman
Tareq Alothman
17,921 Points

I think your problem is missing the column name in the order by clause

ORDER BY LENGTH(TITLE) DESC LIMIT 1