What does the GBase 8t round function mean and does it function the same as the Oracle round functio

Oracle Round works as follows:

round(x[,y])

Function] returns rounded values.

Parameters] x, y, numeric expression, if y is not an integer, then truncate the y integer part, if y>0 then round to y decimal place, if y is less than 0 then round to the left of the decimal point y place.

Returns] number.

Example] select round(,,round(,,round( from dual;

Returns: , 5600, 5556

Similar] trunc(x[,y]) returns the truncated value, which is used in the same way as round(x[,y]), but is not rounded.

I have also encountered such a situation, and I have asked God for advice.

The Oracle Round function (rounding) is a value that is rounded to a specified number of decimal places.

How to use: select round( number, [decimal_places ] from dual

where number is the value to be intercepted.

decimals indicate that the number of digits after the decimal point should be retained. optional, ignore it to truncate all decimal parts and round them off. If it is negative, it means the number of digits to the left from the decimal point, and the corresponding integer number is filled with 0 and the decimal is removed.

It is important to note that, unlike the trunc function, the truncated numbers are rounded.

Parameter: number : the value to be processed.

decimal places : Rounded to the nearest decimal place (0 by default).

sample :

select round(, 0) from dual;- Postback 123

select round(, 1) from dual;--Return.

select round(, 2) from dual;--Return.

select round(, 3) from dual;--Return.

The round function in Oracle is used to truncate numbers, and the intercepted numbers are rounded.

Application of the round function in Oracle:

The syntax is round(number,num digits).

where number is the number that needs to be rounded; Num digits are the specified number of digits rounded to the specified decimal place if num digits are greater than 0, rounded to the nearest whole number if num digits are equal to 0, and rounded to the left of the decimal point if num digits are less than 0.

The round function is a rounding function in Oracle. The method used is round(number,[decimals]).

Where: number is the value to be rounded, and decimals indicates that the number of digits after the decimal point needs to be retained. Optional, ignore it to keep 0 decimal places, accurate to single digits; is a negative number and is rounded to the left of the decimal point.

The following example is sql> select round(,2 round(,2),3 round(,2),4 round(,-2),5 round(,-2).

6 from dual;

round（ round（,2） round（,2） round（,-2） round（,-2）

Usage of the round function in Excel.

round(number,decimals)

number is the number to be rounded, and decimals is the number of digits specified to keep the decimal place.

The value of decimals can be positive, 0, or negative. When the value of decimals is positive, the data after the decimal point is rounded; When the value of decimals is 0, the integer closest to number is returned; When the value of decimals is negative, the data before the decimal point is rounded to the nearest decimal place, and the rounded data is occupied with 0.

The following example is shown in round(,2) The result is as follows:

round(,0) returns 123

round(,-2) returns 100

An oracle round function is a value that is rounded to a specified number of decimal places.

Usage: select round( number, [decimal places] from dual

Parameter: number : the value to be processed.

decimal places : Rounded to the nearest decimal place (0 by default).

Specific cases: a, select round(160 3,3) from dual; -Outcome.

b、select round(160/3,1) from dual;-Outcome.

c、select round(160/3,0) from dual;- Result 53

d、select round(160/3,-1) from dual;- Result 50

e、select round(160/3,-2) from dual;- Result 100

The Oracle Round function means rounding, which returns a value that is rounded to a specified number of decimal places.

An example of how to use the Oracle Round function is as follows:

select round( number, [decimal_places ] from dual

1. The parameter number refers to the value that needs to be processed, which is the value that must be filled.

2. The parameter decimal places refers to the number of decimal places that should be taken when rounding the operation, the parameter can not be filled, and when it is not filled, the system takes 0 by default for the number of decimal places.

3. Function application examples:

select round(, 0) from dual;The result was: 988

select round(, 1) from dual;The result is:

select round(, 2) from dual;The result is:

select round(, 3) from dual;The result is:

select round(, 2) from dual;The result is:

How to use the Oracle Round function (rounding).

Description : Returns a value that is rounded to the specified number of decimal places.

select round( number, [decimal_places ] from dual

Parameter: number : the value to be processed.

decimal places : Rounded to the nearest decimal place (0 by default).

sample :

select round(, 0) from dual;- Postback 123

select round(, 1) from dual;--Return.

select round(, 2) from dual;--Return.

select round(, 3) from dual;--Return.

select round(, 2) from dual;--Return.

Rounding functions. There are two parameters. The first parameter is the object to be manipulated, and the second parameter is the number of decimal places to be kept.

round function.

The syntax is round(number, num digits), where number is a number that needs to be rounded; Num digits are the specified number of digits rounded to the specified decimal place if num digits are greater than 0, rounded to the nearest whole number if num digits are equal to 0, and rounded to the left of the decimal point if num digits are less than 0.

How to use the Oracle Round function (rounding).

Description : Returns a value that is rounded to the specified number of decimal places.

select round( number, [decimal_places ] from dual

Parameter: number : the value to be processed.

decimal places : Rounded to the nearest decimal place (0 by default).

sample :

select round(, 0) from dual;- Postback 123

select round(, 1) from dual;--Return.

select round(, 2) from dual;--Return.

select round(, 3) from dual;--Return.

select round(, 2) from dual;--Return.

1. There is no problem for multi-threaded calls to stored procedures, but there may be concurrency conflicts caused by the tables processed by stored procedures, and the CPU capital occupies a lot of disk reads and writes on weekdays.

round(,2), the output result is rounded to 2 decimal places. The database you're talking about hasn't been used, I don't know.

1. There is no problem with multi-threaded calls to stored procedures, but there may be concurrency conflicts between the tables processed by the stored procedures, and the CPU capital occupies a lot of disk reads and writes. View the original post of the friend burial".

GBASE is developed on the basis of MySQL, so basically MySQL functions can be used on Gbase.

The meaning of the randbetween function is to return a random integer between a minimum value greater than or equal to the specified value and less than the specified maximum value. A new value will be returned each time the worksheet is calculated.

For example: randbetween(1,100): A random integer (variable) greater than or equal to 1 and less than 100

randbetween(-1,1): A random integer (variable) greater than or equal to -1 and less than 1

The round function returns a value rounded to a specified number of digits, such as: round(, 1) rounding to a decimal place (round(, 1) rounding to a decimal place (round(, 2) rounding to two decimal places (round(, 1) rounding to one decimal place (20).

Hello, gbase is compatible with mysql function syntax, mysql functions can be used in gbase, but you need to refer to the manual, because there may be some differences in the form of parameters.