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 95 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
Excellent

at

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

« previous next »
 

Did you know?

More than nineteen million Americans carry the factor V gene that causes blood clots, pulmonary embolism, and heart disease.

Did you know?

The people with the highest levels of LDL are Mexican American males and non-Hispanic black females.

Did you know?

Patients who have been on total parenteral nutrition for more than a few days may need to have foods gradually reintroduced to give the digestive tract time to start working again.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

About one in five American adults and teenagers have had a genital herpes infection—and most of them don't know it. People with genital herpes have at least twice the risk of becoming infected with HIV if exposed to it than those people who do not have genital herpes.

Serum Values for Thyroid Function Tests Serum Values for Thyroid Function Tests
Number and label designations for oxygen sensors. Bank 1 is the bank where cylinder number 1 is ... Number and label designations for oxygen sensors. Bank 1 is the bank where cylinder number 1 is ...
The two most common deformities of the spinal column are scoliosis and kyphosis. The two most common deformities of the spinal column are scoliosis and kyphosis.
Testing sensory function of the trigeminal nerve Testing sensory function of the trigeminal nerve
Write equation for each function Write equation for each function
Prove the argument using two column proof numbers 2 and 5 only. Prove the argument using two column proof numbers 2 and 5 only.
Video: ACTH/Cortisol (glycogenolysis, protein catabolism, lipolysis and gluconeogenesis)

For a complete list of videos, visit our video library