SQL Code Best Practices

1. Uppercase Keywords

Uppercasing SQL keywords improves code readability by clearly distinguishing keywords from identifiers.

-- Recommended
SELECT id, name FROM users WHERE status = 'active';

-- Not recommended
select id, name from users where status = 'active';

2. Use Indentation Wisely

For complex queries, place each clause on a new line with indentation for clearer structure.

SELECT
  u.id,
  u.name,
  COUNT(o.id) AS order_count
FROM users u
  LEFT JOIN orders o ON u.id = o.user_id
WHERE u.status = 'active'
GROUP BY
  u.id,
  u.name
ORDER BY order_count DESC;

3. Use Meaningful Aliases

Table and column aliases should be concise but meaningful. Avoid single-letter aliases unless it's a common convention.

-- Recommended
SELECT
  user.id,
  user.name,
  order.total_amount
FROM users user
  JOIN orders order ON user.id = order.user_id;

-- Not recommended
SELECT a.id, a.name, b.total_amount
FROM users a JOIN orders b ON a.id = b.user_id;

4. Align Column Names

Aligning column names in SELECT statements can improve readability.

SELECT
  id          AS user_id,
  name        AS user_name,
  email       AS user_email,
  created_at  AS registration_date
FROM users;

5. Be Consistent

Maintain consistent formatting style across your project or team. Use our tool to standardize SQL code format.