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

Both Mobutu of Zaire and Nkrumah of Ghana ______________________.   A. stole large amounts of money   B. oppressed their opponents   C. passed a law th
PLEASE help me with these thanks
please help i'm so confused
Eloise is investing in a retirement account. She plans on adding an additional $50 at the end of every year and the expected monthly rate of return is 0.25% of
Explain how the red scare the sacco and vanzetti case and the rise of the ku klux klan reflected concerns held by many americans
Complete this statement. food service gloves:
What is the bend in a rock?
A scientist splits 9 liters of pond water among 10 jars. The jars have the same amount, how many millimeters of pond water in each jar
Alice adventure in wonderland which words in paragraph 7 helped you to determine the meaning of indignant
Artichokes, olives and almonds can only be produced in the ________ biome. mediterranean tropical savanna tropical rain forest midlatitude grassland