w3resource
SQL exercises

SQL exercises on employee Database: Count the no. of characters with out considering the spaces for each name

SQL employee Database: Exercise-8 with Solution

[An editor is available at the bottom of the page to write and execute the scripts.]

8. Write a query in SQL to count the no. of characters with out considering the spaces for each name.

Sample table: employees


Pictorial Presentation:

SQL exercises on employee Database: Count the no. of characters with out considering the spaces for each name

Sample Solution:

SELECT length(trim(emp_name))
FROM employees;

Sample Output:

 length
--------
      7
      5
      5
      5
      7
      5
      8
      6
      4
      6
      6
      6
      6
      6
(14 rows)

Practice Online


Sample Database: employee

employee database structure

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a query in SQL to list the employees with Hire date in the format like February 22, 1991.
Next: Write a query in SQL to list the emp_id, salary, and commission of all the employees.

What is the difficulty level of this exercise?