Home >> SQL >> LENGTH() aggregate function in SQL

LENGTH() aggregate function in SQL

LENGTH() return length of word.

Syntax

LENGTH(column_name)

Example

SELECT city,LENGTH('city') AS citylength FROM employee

Output

Delhi        5

Lucknow   7

Post Your Comment

Next Questions
TRIM() aggregate function
LTRIM() aggregate function
RTRIM() aggregate function
Create database
Drop database
Select database
Create table
Drop table
Truncate table
Insert query
Select table
Where clause
AND Clause
OR Clause
Update query
Delete query
Like clause
IN clause
Order By
Group By
Distinct keyword
Sorting
Between
Having
Union

Copyright ©2022 coderraj.com. All Rights Reserved.