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

Parameters:

 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 functions:

row()

Here’s how to use row() function.

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

Parameters:

 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 =A4.keys(ORDERID,SELLERID) Set multiple keys 6 =[1,17].row(A4) Find the record where key values are [1,17]

Related functions:

## k.row()

Description:

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

Syntax:

k.row(T)

Note:

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

Parameters:

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

Return value:

A record

Example:

 A 1 =demo.cursor("select EID,NAME,GENDER from employee where EID< 10") Return a cursor 2 =A1.memory() Return a memory table 3 =A2.keys(EID) Set EID as 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 memory table 6 =[3,"F"].row(A2) Find the record where the primary key value is [3,"F"] 