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

aliotak

  • Member
  • Posts: 326
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

Did you know?

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

Did you know?

Fewer than 10% of babies are born on their exact due dates, 50% are born within 1 week of the due date, and 90% are born within 2 weeks of the date.

Did you know?

Sperm cells are so tiny that 400 to 500 million (400,000,000–500,000,000) of them fit onto 1 tsp.

A humpback whale tail displaying wavy rear edges A humpback whale tail displaying wavy rear edges
Fights for dominance are normally brief, and sometimes merely displaying dominant gestures without p Fights for dominance are normally brief, and sometimes merely displaying dominant gestures without p
The correct statement about hormones-insulin and glucagon The correct statement about hormones-insulin and glucagon
The recent mass upheavals in Tunisia, Egypt, Libya, Yemen, and Syria gave political scientists a cha The recent mass upheavals in Tunisia, Egypt, Libya, Yemen, and Syria gave political scientists a cha
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 2) How to create a table of values displaying commission and earnings (Question 2)
Video: Carbon fixing adaptations Animation

For a complete list of videos, visit our video library