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 79 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

adf223

  • Member
  • Posts: 304
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Not getting enough sleep can greatly weaken the immune system. Lack of sleep makes you more likely to catch a cold, or more difficult to fight off an infection.

Did you know?

The toxic levels for lithium carbonate are close to the therapeutic levels. Signs of toxicity include fine hand tremor, polyuria, mild thirst, nausea, general discomfort, diarrhea, vomiting, drowsiness, muscular weakness, lack of coordination, ataxia, giddiness, tinnitus, and blurred vision.

Did you know?

Hypertension is a silent killer because it is deadly and has no significant early symptoms. The danger from hypertension is the extra load on the heart, which can lead to hypertensive heart disease and kidney damage. This occurs without any major symptoms until the high blood pressure becomes extreme. Regular blood pressure checks are an important method of catching hypertension before it can kill you.

Did you know?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

Did you know?

In women, pharmacodynamic differences include increased sensitivity to (and increased effectiveness of) beta-blockers, opioids, selective serotonin reuptake inhibitors, and typical antipsychotics.

A partially submerged alligator displaying a typical ambush position A partially submerged alligator displaying a typical ambush position
The correct statement about hormones-insulin and glucagon The correct statement about hormones-insulin and glucagon
Candidates for jobs are sometimes rejected when the prospective employer finds negative images or ... Candidates for jobs are sometimes rejected when the prospective employer finds negative images or ...
Step 3 in the diagnostic process is to retrieve any stored diagnostic trouble codes. Step 3 in the diagnostic process is to retrieve any stored diagnostic trouble codes.
How to create a table of values displaying commission and earnings (Question 1) How to create a table of values displaying commission and earnings (Question 1)
Video: Skin Cancer

For a complete list of videos, visit our video library