Mamadorunrun7646 Mamadorunrun7646
  • 14-09-2019
  • Computers and Technology
contestada

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

Respuesta :

wein7145 wein7145
  • 14-09-2019

Answer:

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.

Answer Link

Otras preguntas

What is something that happened In the Colombian exchange other than transferring food and tech and diseases ASAP
In the equation, 23 + b= 456 the variable is what
Reread the highlighted stanza.What is one way the speaker thinks that the sun and a toddler are alike
The art,music, and philosophy of the medieval period of Europe generally dealt with what ?
Match each part of the eye with the correct label please help asap
What is the measurement for angle JKL. (2x+5) and (3x-6)
What is 1+1? I need help fast.
2. Which variable will eliminate? * 3x +6y=27 -3x+8y= 1
Mary went to Footlocker to get sneakers. The sneakers cost $125 but they are on sale for 35% off. How much will Mary save on the sneakers and what is the sale p
Determine How the triangles can be proved similar. A. AA SIMILARITY B. SSS SIMILARITY C. SAS SIMILARITY D. NOT SIMILAR