Change Password

Input error
Input error
Input error
Submit

Change Nickname

Current Nickname:
Submit
Search
v4.0
    v4.0

    LIMIT | Limit Length

    Format, Parameters

    LIMIT keeps the first N rows of data in the data stream, and discard the rest rows.

    Syntax:

    • Format: limit <number>
    • Parameters: see table below
    • Affected columns: data columns produced by previous UQL statements and all their homologous columns
    Name Category Specification Description
    <number> int32 ≥ -1 The rows to be kept, all columns will be kept if it is -1

    Analysis

    find().nodes([1, 5]) as nodes
    n(nodes).e()[:2].n() as path
    limit 2
    return path
    

    In the UQL statement above, LIMIT keeps the first 2 rows of the paths resulting from template query.

    See UQL statement and image below to compare Clause LIMIT and Chain Command Parameter .limit()

    find().nodes([1, 5]) as nodes
    n(nodes).e()[:2].n().limit(2) as path
    return path
    

    Parameter .limit() keeps the first 2 rows of paths resulting from each of the two template queries, and it keeps 4 rows from the result

    Common Usage

    Example: find all cards that transferred money to Card CA029, return 10 cards in a descending order of their balances; that is, to find the 10 cards with the highest balances

    n({_id == "CA029"}).le({@transfer}).n({@card} as n)
    with distinct (n)
    order by n.balance DESC
    return n{*} limit 10
    

    Example: find all cards that transferred money to Card CA029, return them in a descending order of their balances

    n({_id == "CA029"}).le({@transfer}).n({@card} as n)
    with distinct (n)
    limit 10 return n{*}
    order by n.balance DESC
    
    Please complete the following information to download this book
    *
    公司名称不能为空
    *
    公司邮箱必须填写
    *
    你的名字必须填写
    *
    你的电话必须填写
    *
    你的电话必须填写