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

brbarasa

  • Member
  • Posts: 308
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Did you know?

People often find it difficult to accept the idea that bacteria can be beneficial and improve health. Lactic acid bacteria are good, and when eaten, these bacteria improve health and increase longevity. These bacteria included in foods such as yogurt.

Did you know?

The U.S. Preventive Services Task Force recommends that all women age 65 years of age or older should be screened with bone densitometry.

Did you know?

Over time, chronic hepatitis B virus and hepatitis C virus infections can progress to advanced liver disease, liver failure, and hepatocellular carcinoma. Unlike other forms, more than 80% of hepatitis C infections become chronic and lead to liver disease. When combined with hepatitis B, hepatitis C now accounts for 75% percent of all cases of liver disease around the world. Liver failure caused by hepatitis C is now leading cause of liver transplants in the United States.

Did you know?

More than 34,000 trademarked medication names and more than 10,000 generic medication names are in use in the United States.

Model of a sequential study in which two cohorts were followed beginning at age 20. One cohort was f Model of a sequential study in which two cohorts were followed beginning at age 20. One cohort was f
Determination of the number of theoretical stages Determination of the number of theoretical stages
How to find the anti-derivative of a function (Part 3) How to find the anti-derivative of a function (Part 3)
List transformations and Create a table of values for the following log function: List transformations and Create a table of values for the following log function:
Effects of disrupted growth hormone function Effects of disrupted growth hormone function
Chromosome Number in Selected Animal Species Chromosome Number in Selected Animal Species
Video: Osteoporosis

For a complete list of videos, visit our video library