Oracle: List the names, salary of those employees whose names having a character set 'll' together

Oracle Wildcard special Operator: Exercise-10 with Solution

Write a query to list the names (first and last), salary of those employees whose names having a character set ’ll’ together.

Sample table : employees

Sample Solution:

Oracle Code:

SELECT  first_name, last_name, salary 
FROM employees 
where first_name LIKE ’%ll%’;

Output:

FIRST_NAME           LAST_NAME                     SALARY
-------------------- ------------------------- ----------
Valli                Pataballa                       4800
Shelli               Baida                           2900
Randall              Matos                           2600
Allan                McEwen                          9000
Danielle             Greene                          9500
William              Smith                           7400
Ellen                Abel                           11000
Kelly                Chung                           3800
Randall              Perkins                         2500
Shelley              Higgins                        12008
William              Gietz                           8300

11 rows selected.

Pictorial Presentation:

Improve this sample solution and post your code through Disqus.

Previous: Write a query to list the names (first and last), salary of those employees whose salary is four digit number ending with Zero.
Next: Write a query to list first_name, last_name of employees with the pattern 'l_x' in their first name.