__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
-----------
ROWS clause
-----------
Function:
Limits the number of rows retrieved from a select expression. For the
top-level select statement, it would mean a number of rows sent to the host
program.
Author:
Dmitry Yemanov <yemanov@yandex.ru>
Syntax rules:
SELECT ... [ORDER BY <expr_list>] ROWS <expr1> [TO <expr2>]
Scope:
DSQL, PSQL
Example(s):
1. SELECT * FROM T1
UNION ALL
SELECT * FROM T2
ORDER BY COL
ROWS 10 TO 100
2. SELECT COL1, COL2, ( SELECT COL3 FROM T3 ORDER BY COL4 DESC ROWS 1 )
FROM T4
3. DELETE FROM T5
ORDER BY COL5
ROWS 1
Note(s):
1. ROWS is a more understandable alternative to the FIRST/SKIP clauses with
some extra benefits. It can be used in unions and all kind of subqueries.
It is also available in the UPDATE/DELETE statements.
2. When <expr2> is omitted, then ROWS <expr1> is a semantical equivalent for
FIRST <expr1>. When both <expr1> and <expr2> are used, then ROWS <expr1>
TO <expr2> means:
FIRST (<expr2> - <expr1> + 1) SKIP (<expr1> - 1). Note that there's no
semantic equivalent for a SKIP clause used without a FIRST clause.
3. The ROWS-clause is not defined in the SQL standard. For SELECT, consider
the alternative OFFSET and FETCH clauses defined in the SQL standard.