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 44 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
Wow, this really help

kishoreddi

  • Member
  • Posts: 329
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

Did you know?

There are 60,000 miles of blood vessels in every adult human.

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Did you know?

Nearly 31 million adults in America have a total cholesterol level that is more than 240 mg per dL.

Example of a patient statement. Example of a patient statement.
A typical bank statement. A typical bank statement.
Example of Reconciling a Bank Statement Example of Reconciling a Bank Statement
Example of Reconciling a Bank Statement Cont. Example of Reconciling a Bank Statement Cont.
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)
How to create a table of values displaying commission and earnings (Question 2) How to create a table of values displaying commission and earnings (Question 2)
Video: Rods and Cones Animation

For a complete list of videos, visit our video library