Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Trim and Normalise Names

Names contain leading and trailing spaces. Return id and the trimmed name, ordered by id.

Table schema

Users(id INT PRIMARY KEY, name VARCHAR(50))

Sample data

id | name
1 | '  Amit  '
2 | 'Riya '

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.