SQL Experts Don't forget that extra comma at the end

Опубликовано: 14 Ноябрь 2024
на канале: ETL-SQL

878

Free SQL Pattern Training: https://etlsql.kartra.com/page/sps-fr...

Do you understand SQL but still cannot write SQL queries correctly ?
Are you afraid to switch jobs because of the SQL interview rounds or have you failed SQL Interview earlier ?
If you are someone who understands SQL and need more confidence to solve SQL queries correctly, I would like to share my recent online course especially created for you.
Check for more details: https://etlsql.kartra.com/page/sql-pa...

2️⃣ *Missing or Extra comma:*

This is another common SQL error in the beginners code. Especially in the INSERT or SELECT column list. Take few extra seconds to confirm if you have added comma between each column in the list or if there is extra column before first or after last column.

Another reason I have seen is many times developer use regex to add comma at the end or at the beginning of column name. Especially when the column list is huge and consists of many columns. They copy-paste the output to the SQL query and forget to remove comma at the start or at the end.