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;

참조

공식 사양 보기