Employee management exercise 6

Back to Employee management

Select all the data of employees whose last name begins with an "S".

| SELECT ssn, name, lastname, department FROM employees WHERE lastname =* S
4 rows 0 msec

ssn	name	lastname	department
222364883	Carol	Smith	37
326587417	Joe	Stevens	37
631231482	David	Smith	77
845657246	Kumar	Swamy	14

There are plenty of operators to compare. =* means begins with