Question

Write suitable SQL query for the following:

To display the data from the column (attribute) username in the Users table, after eliminating any leading and trailing spaces.

Answer 1

SELECT TRIM(username) FROM Users;