SELECT

使用标准 SQL SELECT 语句查询 Lance 表中的数据。

从表中选择所有数据

SELECT * FROM users;

选择特定列

SELECT id, name, email FROM users;

使用 WHERE 子句查询

SELECT * FROM users WHERE age > 25;

聚合查询

SELECT department, COUNT(*) as employee_count 
FROM users 
GROUP BY department;

连接查询

SELECT u.name, p.title
FROM users u
JOIN projects p ON u.id = p.user_id;