Last updated Nov 17, 2024

Comments in SQL are used to explain sections of SQL statements, or to prevent execution of SQL statements. They are helpful for documentation purposes and making code more readable.

1
2

-- This is a single-line comment
SELECT * FROM Employees;

1
2
3

/* This is a multi-line comment
   that covers multiple lines */
SELECT * FROM Employees;

Comments are a crucial part of writing maintainable, understandable SQL code, especially in complex queries or when working in teams. They allow you to explain why a certain SQL statement is used, or to temporarily disable parts of SQL code during testing and development.

• SQL - W2 Select and Filter Data - Introduction
• SQL - W2 Select and Filter Data - Creating a Database
• SQL - W2 Select and Filter Data - Running Scripts
• SQL - W2 Select and Filter Data - SELECT Statement
• SQL - W2 Select and Filter Data - WHERE Clause and Comparison Operators
• SQL - W2 Select and Filter Data - Logical Operators
• SQL - W2 Select and Filter Data - ORDER BY
• SQL - W2 Select and Filter Data - SQL Comments
• Next: SQL - W2 Select and Filter Data - Note on Semicolons
• SQL - W2 Select and Filter Data - Practice Assignment