query writing Archives - SelectDistinct.io

Before! The comma separator before field name is always preferred. There, that was easy.

You’ve come here to either win an argument with a coworker — in which case I hope you’re here to find proof for having the comma separator before field names, or you’re doing it wrong — or you’re here to learn. In either case, the comma comes before field names. So, allow me to justify when and, more importantly, why I use one variation over the other:

Example of both comma separators


SELECT
  TBL.FOO, --<----After
  TBL.BAR
FROM DUAL;

SELECT
  TBL,FOO
 ,TBL.BAR --<-----Before
FROM DUAL;

SELECT

TBL.FOO, --<----After

TBL.BAR

FROM DUAL;

SELECT

TBL,FOO

,TBL.BAR --<-----Before

FROM DUAL;

You’ll notice that both these queries are very much identical, with the exception of the placement of the delimiting comma between each field in the select clause of course.

There are two schools of thought here:
Continue reading →

Tag: query writing

Comma Separator Before Field Name Or After?

Example of both comma separators