• esProc
Tutorial
Function Reference
Code Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# round()

Description:

Truncate data at the specified position and round off the remaining part.

Syntax:

round(numberExp, {nExp})

Note:

The function truncates the data numberExp at the specified position nExp, and rounds off the remaining part.

Parameter:

 numberExp Data to be truncated nExp An integer specifying the position at which data is truncated; taken as 0 when it is omitted >0: Truncate data at nExp decimal place(s) to the right of the decimal point <0: Truncate data at nExp decimal place(s) to the lft of the decimal point =0: Truncate data at the current decimal place

Return value:

Numeric value

Example:

 round(3451251.274,0) 3.45125e+06 round(3451251.274,-1) 3.45125e+06 round(3451251.274,-2) 3.4513e+06 round(3451251.274,1) 3.45125e+06 round(3451251.274,2) 3.45125e+06

Related function:

row()

Here’s how to use row() functions.

## k. row()

Description:

Find the record where the key value(s) is/are the specified one(s).

Syntax:

k.row(T)

Note:

The function finds the record whose key value is k in a record sequence/a table sequence/a sequence.

Parameter:

 k A key value; multiple key values will be represented by a sequence T A record sequence/a table sequence/a sequence

Return value:

A record

Example:

 A 1 =demo.query("select * from sales") 2 =A1.keys(ORDERID) Set the key. 3 =2.row(A1) Find the record whose key value is 2. 4 =A1.select() Generate a record sequence from A1’s table sequence. 5 =A1.keys(ORDERID,SELLERID) Set multiple keys. 6 =[1,17].row(A1) Find the record where key values are [1,17] .

Related function:

## k.row()

Description:

Find records from an in-memory table according to the specified primary key value(s).

Syntax:

k.row(T)

Note:

The function finds records from in-memory table T according to the specified primary key value(s) k.

Parameter:

 k Primary key value(s); use a sequence to represent multiple key values T An in-memory table

Return value:

Record

Example:

 A 1 =demo.cursor("select EID,NAME,GENDER from employee where EID< 10") Return a cursor. 2 =A1.memory() Return an in-memory table. 3 =A2.keys(EID) Set EID as the in-memory table’s key. 4 =2.row(A2) Find the record where the primary key value is 2. 5 =A2.keys(EID,GENDER) Set EID and NAME as the keys of the in-memory table 6 =[3,"F"].row(A2) Find the record where the primary key value is [3,"F"].