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

Light, x-rays, microwaves, and radio waves are examples of which type of energy?
Compare the ancient hawaiian caste system to modern-day society
solve the compound inequality 10 >= 7 + 3x and 9-4x<=1 . show steps please.
Which is the least severe form of heat illness? 1.Heat cramps 2.Heat exhaustion 3.Heat fatigue 4.Heat stroke I think Heat cramps
For the following chemical reaction... HCN (aq) + KOH (aq)----> H2O (l) + KCN (aq) write the net ionic equation, including the phases.
solve for x. 5(x 1) = 4(x 8)
In the American economy, the goal of economic equity is MOST connected with... A.) Giving participants a fair chance to succeed B.) Restoring laissez faire cap
Name three possible agendas and one example of each that you might find in the media.
find the difference 7/78- 3 1/4
Let f(x)= 3x – 6 and g(x) = x –2. Find f/g and its domain.