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