SQL 查询构建器

可视化构建 SQL SELECT 查询。添加列、条件、JOIN 和排序，格式化输出。

Table Name

Limit

Offset

DISTINCT

Columns

JOINs

WHERE Conditions

GROUP BY

ORDER BY

Generated SQL

SELECT
  *
FROM users;

SQL SELECT Queries - 技术详情

SQL SELECT statements retrieve data from databases. Use WHERE for filtering, JOIN for combining tables, GROUP BY for aggregation, ORDER BY for sorting, and LIMIT for pagination. Different SQL dialects have minor syntax variations.

命令行替代方案

SELECT u.name, COUNT(o.id) as orders\nFROM users u\nLEFT JOIN orders o ON u.id = o.user_id\nWHERE u.active = true\nGROUP BY u.id\nORDER BY orders DESC;

参考

查看官方规范