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)

3451251.0

round(3451251.274,-1)

3451250.0

round(3451251.274,-2)

3451300.0

round(3451251.274,1)

3451251.3

round(3451251.274,2)

3451251.27

Related functions:

ceil()

floor()

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:

A.find()

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"]