List the name, department, phone number, and email address of employees with a phone number beginning with "5-".

Question

Kc

Computers & Technology

1 March, 04:50

List the name, department, phone number, and email address of employees with a phone number beginning with "5-".

+4

Answers (1)

Know the Answer?

Tabitha Clements · Answer 1

select name, department, phone_number, email from employee e

where e. phone_number like '5-%'

Explanation:

On Chegg + SQL textbook

here we are making use of like operator to match any phone number that starts with '5-'. Like operator has two wild card that can be used with it.

(%) - -This represents zero, one or multiple characters.

(_) - - This represents a single character.