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

Author Question: Count function does which of the following? A) Returns the number of values in the column for the ... (Read 94 times)

jlmhmf

  • Hero Member
  • *****
  • Posts: 552
on: Jul 7, 2018
Count function does which of the following?
 
  A) Returns the number of values in the column for the selected rows
  B) Returns the highest value in the column for the selected rows
  C) Returns the total of the values in the column for the selected rows
  D) Returns the average of the values in the column for the selected rows

Question 2

In Oracle, the statement used to retrieve all the jobs with jobid greater than 5 and less than 8,
  displaying only jobids and associated dates, would be which of the following?
 
  A) Select jobid, date From Job Where jobid 5 and 8
  B) Select jobid, date From Job Where jobid >5 And <8
  C) Select jobid, date From Job Where jobid >=5 and <=8
  D) Select jobid, date From Job Where jobid between 5 and 8


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

jxjsniuniu

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

A

Answer to Question 2

B


jlmhmf

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

nathang24

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

« previous next »
 

Did you know?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Did you know?

Approximately 500,000 babies are born each year in the United States to teenage mothers.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

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?

A serious new warning has been established for pregnant women against taking ACE inhibitors during pregnancy. In the study, the risk of major birth defects in children whose mothers took ACE inhibitors during the first trimester was nearly three times higher than in children whose mothers didn't take ACE inhibitors. Physicians can prescribe alternative medications for pregnant women who have symptoms of high blood pressure.

Differences in the number and location of flagella. Differences in the number and location of flagella.
pH values of common solutions pH values of common solutions
Single-dose drug administration. Pharmacokinetic values for this drug are as follows: onset of ... Single-dose drug administration. Pharmacokinetic values for this drug are as follows: onset of ...
How to find the anti-derivative of a function (Part 1) How to find the anti-derivative of a function (Part 1)
How to horizontally shift a sinusoidal function (y=a*sin⁡b(x−c)+d) How to horizontally shift a sinusoidal function (y=a*sin⁡b(x−c)+d)
Periodic Function p2 Periodic Function p2
Video: Carbon fixing adaptations Animation

For a complete list of videos, visit our video library