如何在Postgres中选择前几条记录。不是类似的问题

CREATE TABLE employees (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    age INT
);

SELECT * FROM employees LIMIT 5;

SELECT * FROM employees ORDER BY age ASC LIMIT 5;

SELECT * FROM employees ORDER BY id ASC OFFSET 10 LIMIT 5;

-- 创建示例表
CREATE TABLE employees (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    age INT
);

-- 插入一些示例数据
INSERT INTO employees (name, age) VALUES
('Alice', 30),
('Bob', 25),
('Charlie', 35),
('David', 28),
('Eve', 32),
('Frank', 29),
('Grace', 31),
('Hank', 34),
('Ivy', 27),
('Jack', 33);

-- 选择前5条记录
SELECT * FROM employees LIMIT 5;