Estas fueron todas las que se me ocurrieron. Y eso que antes le tenía un mieeedo a SQL. Ahora lo veo tan simple y hermoso
SELECT *
FROM platzi.alumnos AS alumnos
FETCH FIRST 5 ROWS ONLY;
SELECT *
FROM platzi.alumnos
LIMIT 5;
SELECT *
FROM (
SELECT ROW_NUMBER () OVER() AS row_id, *
FROM platzi.alumnos
)AS alumnos_with_row_nums
WHERE row_id < 6
;
SELECT *
FROM (
SELECT ROW_NUMBER () OVER() AS row_id, *
FROM platzi.alumnos
)AS alumnos_with_row_nums
WHERE row_id <=5
;
SELECT *
FROM (
SELECT ROW_NUMBER () OVER() AS row_id, *
FROM platzi.alumnos
)AS alumnos_with_row_nums
WHERE row_id BETWEEN 1 and 5
;
