name starts with s 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' ;