﻿ SQL: List the employees, having six characters to their name

# SQL Exercise: List the employees, having six characters to their name

## SQL employee Database: Exercise-17 with Solution

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

17. From the following table, write a SQL query to find the names of the employees whose length is six. Return employee name.

Sample table: employees

Pictorial Presentation:

Sample Solution:

``````SELECT emp_name
FROM employees
WHERE length(emp_name)=6;
``````

Sample Output:

``` emp_name
----------
TUCKER
JULIUS
MARKER
(6 rows)
```

## Practice Online

Sample Database: employee

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

Previous SQL Exercise: Employees whose salary is over 3000 after a 25% raise.
Next SQL Exercise: List the employees who joined in the month January.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

﻿

## SQL: Tips of the Day

Count the number of occurrences of a string in a VARCHAR field?

```SELECT
title,
description,
ROUND (
(
LENGTH(description)
- LENGTH( REPLACE ( description, "value", "") )
) / LENGTH("value")
) AS count
FROM <table>
```

Ref: https://bit.ly/3PvNdT4