4 Write a SQL statement to show the employee number employee

4. Write a SQL statement to show the employee number, employee name, hiredate of employees where name has 2 L\'s.

Solution

Answer

Select name , hiredate

From employees

where name like \"%LL%\"

Explanation:

We have select the name and hiredate

where name has 2L

it means you apply where condition like operator to identify name has 2L