Count the Characters in Review Comments in SQL

Question:

Count the Characters in Review Comments

 Write a query to display the total count of characters in the review comment given by the guest. Display  the result set in the ascending order of count of characters. Give alias name as COMMENTS_LENGTH.

Count the Characters in Review Comments

Code:

Main.sql

select length(comments) as COMMENTS_LENGTH 
from review 
order by COMMENTS_LENGTH;

Recommended:

Leave a Comment

Your email address will not be published. Required fields are marked *