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 does semicolon mean in math
Which is the longest? A. 2 km B. 25 m C. 2,500 cm D. 3,000 mm
Cellular respiration generates a total of 36-38 ATP molecules. How many of these come solely from glycolysis
The best way to describe language divergence is as __________.
The front leg of an iguana and the wing of a bird look different, but both limbs likely evolved from the same limb of a shared ancestor. Structures such as thes
part: 1 The width of a rectangle is 13 its length, l. Which expression represents the perimeter of the rectangle? 1/3 L+L 2(L+1/3L) 4×1/3L 4(l+1/3L) Part 2 The
Which emperor blamed Christians for setting fire to Rome? A. Marcus Aurelius B. Nero C. Brutus D. Caligula
Identify the type of clause or phrase in the sentence below. It is necessary to be aware of one's surroundings when living in such close proximity to the desert
What are the main functions of meiosis
Lorelei filled her 5-gallon jug with water. How many times could she fill her 2-quart canteen with water from the jug?