database:oracle:limit-rows
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
database:oracle:limit-rows [2018/03/04 19:54] – created odefta | database:oracle:limit-rows [2023/07/04 19:36] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Limit returned rows (Oracle 12) ====== | ====== Limit returned rows (Oracle 12) ====== | ||
- | |||
<code sql> | <code sql> | ||
- | select e.employee_id from employees e fetch first 10 rows only | + | select e.employee_id from employees e FETCH first 10 rows only |
</ | </ | ||
+ | \\ EMPLOYEE_ID | ||
+ | \\ 100 | ||
+ | \\ 101 | ||
+ | \\ 102 | ||
+ | \\ 103 | ||
+ | \\ 104 | ||
+ | \\ 105 | ||
+ | \\ 106 | ||
+ | \\ 107 | ||
+ | \\ 108 | ||
+ | \\ 109 |
database/oracle/limit-rows.1520186096.txt.gz · Last modified: 2023/07/04 19:36 (external edit)