A GUIDE TO SQL
A GUIDE TO SQL
9th Edition
ISBN: 9781305897397
Author: Pratt
Publisher: CENGAGE L
Expert Solution & Answer
Book Icon
Chapter 8, Problem 2RQ

Explanation of Solution

Round a number to a specific number of decimal places in Oracle, Access and SQL Server:

  • In Oracle, Access and SQL server, user can round a number to a specific number of decimal places by using “ROUND” function.

“ROUND” function:

  • This function is used to rounds a number to a specified number of decimal places.
  • This function contains more than one argument.
  • Syntax for “ROUND” function:

    ROUND(number, DecimalPlaces)

    • From the given syntax, the argument “number” defines the value to be rounded and the argument “DecimalPlaces” represents the number of decimal places to which to round the result.
    • Consider an example, “ROUND(46.78, 0)” will give the result as “47”...

Explanation of Solution

Remove each value to the right of the decimal places using Oracle, Access and Server:

For Oracle and SQL Server:

For Oracle and SQL server, user can use the “FLOOR” function to remove each number to the right of decimal point.

“FLOOR” function:

  • This function is used to truncate everything to the right of decimal value.
  • Syntax for “FLOOR” function:

    FLOOR(value)

    From the given syntax, the “value” represents numeric value.

Example of “FLOOR” function:

The example for “FLOOR” function in query concept is given below:

SELECT FLOOR(86.32) AS COMPUTED_VALUE;

  • The above query is used to eliminate everything to the right of decimal value using “FLOOR” function.
  • The computed value is represented by “COMPUTED_VALUE” using “AS” operator.

When the query is executed, the following output will be displayed...

Blurred answer
Students have asked these similar questions
If a UDP datagram is sent from host A, port P to host B, port Q, but at host B there is no process listening to port Q, then B is to send back an ICMP Port Unreachable message to A. Like all ICMP messages, this is addressed to A as a whole, not to port P on A. (a)  Give an example of when an application might want to receive such ICMP messages. (b)  Find out what an application has to do, on the operating system of your choice, to receive such messages. (c)  Why might it not be a good idea to send such messages directly back to the originating port P on A?
Discuss how business intelligence and data visualization work together to help decision-makers and data users. Provide 2 specific use cases.
This week we will be building a regression model conceptually for our discussion assignment. Consider your current workplace (or previous/future workplace if not currently working) and answer the following set of questions. Expand where needed to help others understand your thinking:  What is the most important factor (variable) that needs to be predicted accurately at work? Why? Justify its selection as your dependent variable.
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning