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

Author Question: In Oracle, the statement used to retrieve all the jobs with jobid over 5, displaying only jobids ... (Read 26 times)

Engineer

  • Hero Member
  • *****
  • Posts: 527
on: Jul 7, 2018
In Oracle, the statement used to retrieve all the jobs with jobid over 5, displaying only
  jobids and associated dates, would be __________.
 
  Fill in the blanks with correct word

Question 2

In Oracle, the statement used to retrieve all the client data, ordered first by state and
  then by zip code 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

KKcool

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

Select jobid, Date From job Where jobid > 5

Answer to Question 2

Select  From client Order by state, zipcode


Engineer

  • Member
  • Posts: 527
Reply 2 on: Jul 7, 2018
Thanks for the timely response, appreciate it

miss_1456@hotmail.com

  • Member
  • Posts: 289
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

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?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

Did you know?

During pregnancy, a woman is more likely to experience bleeding gums and nosebleeds caused by hormonal changes that increase blood flow to the mouth and nose.

Did you know?

The oldest recorded age was 122. Madame Jeanne Calment was born in France in 1875 and died in 1997. She was a vegetarian and loved olive oil, port wine, and chocolate.

Did you know?

There are immediate benefits of chiropractic adjustments that are visible via magnetic resonance imaging (MRI). It shows that spinal manipulation therapy is effective in decreasing pain and increasing the gaps between the vertebrae, reducing pressure that leads to pain.

An Australian Shepherd-Beagle mix displaying mastery of the "sit" command An Australian Shepherd-Beagle mix displaying mastery of the "sit" command
Celestia displaying Jupiter, Europa and Io Celestia displaying Jupiter, Europa and Io
Example of Reconciling a Bank Statement Cont. Example of Reconciling a Bank Statement Cont.
A greater number of men than women hold full-time jobs, but the gap is closing because of an ... A greater number of men than women hold full-time jobs, but the gap is closing because of an ...
How do men who work in traditionally feminine nurturng jobs and women who work in jobs that give ... How do men who work in traditionally feminine nurturng jobs and women who work in jobs that give ...
To retrieve flash codes from an OBD-I General Motors vehicle, connect terminals A and B with the ... To retrieve flash codes from an OBD-I General Motors vehicle, connect terminals A and B with the ...
Video: New DNA Strand Replication

For a complete list of videos, visit our video library