This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: In Oracle, the statement used to show all employees' social security numbers and names that don't ... (Read 82 times)

Kikoku

  • Hero Member
  • *****
  • Posts: 540
on: Jul 7, 2018
In Oracle, the statement used to show all employees' social security numbers and names
  that don't have jobs assigned to them, would be __________.
 
  Fill in the blanks with correct word

Question 2

In Oracle, the statement used to show all clients' emails and contacts for whom jobs
  have been done, would be __________.
 
  Fill in the blanks with correct word


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

olderstudent

  • Sr. Member
  • ****
  • Posts: 339
Reply #1 on: Jul 7, 2018
Answer to Question 1

Select employee.ssn, employee.name From employee Where employee.ssn Not In (Select Distinct job.ssn From job)

Answer to Question 2

Select client.email, client.contact From client Where client.email In (Select Distinct client.email From job)


Kikoku

  • Member
  • Posts: 540
Reply 2 on: Jul 7, 2018
Excellent

xoxo123

  • Member
  • Posts: 335
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Intradermal injections are somewhat difficult to correctly administer because the skin layers are so thin that it is easy to accidentally punch through to the deeper subcutaneous layer.

Did you know?

Pregnant women usually experience a heightened sense of smell beginning late in the first trimester. Some experts call this the body's way of protecting a pregnant woman from foods that are unsafe for the fetus.

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

A headache when you wake up in the morning is indicative of sinusitis. Other symptoms of sinusitis can include fever, weakness, tiredness, a cough that may be more severe at night, and a runny nose or nasal congestion.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

A lilac, orange and white Satin Peruvian guinea pig (show-length coat) A lilac, orange and white Satin Peruvian guinea pig (show-length coat)
If you want to show differences between items at the same time, a bar graph is more effective than a If you want to show differences between items at the same time, a bar graph is more effective than a
Behavior modification has been useful in raising the amount of social responding by children with ... Behavior modification has been useful in raising the amount of social responding by children with ...
W-4 form used by employees to request IRS withholding. W-4 form used by employees to request IRS withholding.
Economic and Social Development Economic and Social Development
Social Problems: A Critical Power-Conflict Perspective Social Problems: A Critical Power-Conflict Perspective
Video: Replication of DNA and Chromosomes/ How do cells replicate their DNA? (Animation) no Audio

For a complete list of videos, visit our video library