Ask Question
6 March, 16:06

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

+2
Answers (1)
  1. 6 March, 18:41
    0
    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.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “List the name, department, phone number, and email address of employees with a phone number beginning with "5-". ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers