database:oracle:limit-rows
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| database:oracle:limit-rows [2018/03/04 18:00] – odefta | database:oracle:limit-rows [2023/07/04 16: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 | |
| - | EMPLOYEE_ID | + | |
| - | ---- | + | |
| \\ 100 | \\ 100 | ||
| \\ 101 | \\ 101 | ||
database/oracle/limit-rows.1520186411.txt.gz · Last modified: (external edit)