Author Question: In Oracle, the statement used to retrieve client's contact with emails that end in net, from zip ... (Read 20 times)

kwoodring · **on:** Jul 7, 2018

In Oracle, the statement used to retrieve client's contact with emails that end in net,
from zip codes 03223 and 03264, would be __________.

Fill in the blanks with correct word

Question 2

In Oracle, the statement used to retrieve client's contacts with emails that are not from
zip codes 03223 and 03264, would be __________.

Fill in the blanks with correct word

dellikani2015 · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

Select contact, email, zipcode From client Where email Like 'net' And (zipcode = '03223' Or zipcode = '03264')

Answer to Question 2

Select contact, email, zipcode From client Where zipcode Not In ('03223', '03264')