Putting comments with SQL codes

[Admin]

Select
grade,eff_date, -- STRFTIME('%M %D %Y',sal_end_date) AS enddatesalary
FROM salary_range_by_job_classification
WHERE grade = 'Q90H0'

Intend to put STRFTIME(‘%M %D %Y’,sal_end_date) AS enddatesalary under comments. Seems I am making a mistake.

Also tried this way:

Select
grade,eff_date, /* STRFTIME('%M %D %Y',sal_end_date) AS enddatesalary*/
FROM salary_range_by_job_classification
WHERE grade = 'Q90H0'

Again seems incorrect.

---

Reply

---

This is a great example of why everyone should be using the leading comma convention.

The dangling comma is easier to spot.

SELECT grade
, eff_date
, -- STRFTIME('%M %D %Y',sal_end_date) AS enddatesalary
FROM salary_range_by_job_classification
WHERE grade = 'Q90H0'

Leading comma makes it easier to comment out a line:

SELECT grade
    , eff_date
 -- , STRFTIME('%M %D %Y',sal_end_date) AS enddatesalary 
  FROM salary_range_by_job_classification 
WHERE grade = 'Q90H0'

See the difference?

[Author]

Posts