Best practices for writing SQL queries

Re:Best practices for writing SQL queries by karmakaze on Saturday April 10, 2021 @01:40PM (#26763332)

I find it more readable as

  SELECT a.foo, b.bar, g.zed
  FROM alpha a
  JOIN beta b ON a.id = b.alpha_id
  LEFT JOIN gamma g ON b.id = g.beta_id
  WHERE a.val > 1
    AND b.col < 2
  ORDER BY a.foo

Usually only the conditions get deep and can also use extra indented parenthesized parts.

reminder: don't use 'OUTER' it's pure noise

[ Parent | on HN ]

Re:Best practices for writing SQL queries by AdrianB1 on Saturday April 10, 2021 @05:26PM (#26765278)

We are doing something very similar, except we add extra indentation to the joins like you did for the second condition in the WHERE. This is because we strongly separate each block - SELECT, FROM, WHERE, <ORDER>, so everything that is in the FROM block is indented. Same for the SELECT if it so long it goes to a second or third row.

[ Parent | on HN ]