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

Which represents the inverse function f(x)=4x?
On his first day of school, Kareem found the high temperature in degrees Fahrenheit to be 76.1°. He plans to use the function to convert this temperature from
the dashed line on each grid represents y=x. on which grid is y=4x - 2 apparently represented as well?
How was the electoral college established?
Not sure how to work this problem out. I keep getting the incorrect answer
25% of 860 programs is how many?
Suppose the population of a town is 100,000 in 2014. The population increases at a rate of 4.5% every year. What will be the population of the town in 2020? Rou
How long ago was the constitution written?
359 divided by 20 long divison
13. Dr. Jones took out a loan for a new medical instrument cleaning system. The interest paid on the loan was $650. The loan was for 24 months, and the interest