get all employees if name ends with in sql code example

Example: get all employees if name ends with in sql

FIND OUT ALL FIRST_NAME AND LAST NAME FROM EMPLOYEES TABLE 
-- IF THE FIRST NAME START WITH A AND LAST NAME END WITH n

SELECT FIRST_NAME , LAST_NAME 
FROM EMPLOYEES 
WHERE FIRST_NAME LIKE 'A%' AND LAST_NAME LIKE '%n'  ;

Tags:

Misc Example

Related