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

SUBSTR() aggregate function in SQL

SUBSTR() return a portion of characters.

Syntax

SUBSTR(column_name)

Example

SELECT SUBSTR('address',1,10) AS address FROM employee

Output

Rohini New Delhi - 110085

Post Your Comment

Next Questions
ASCII() aggregate function
LENGTH() aggregate function
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

Copyright ©2022 coderraj.com. All Rights Reserved.