
- SQL - Home
- SQL - Roadmap
- SQL - Overview
- SQL - RDBMS Concepts
- SQL - Databases
- SQL - Syntax
- SQL - Data Types
- SQL - Operators
- SQL - Expressions
- SQL - Comments
- SQL Database
- SQL - Create Database
- SQL - Drop Database
- SQL - Select Database
- SQL - Rename Database
- SQL - Show Databases
- SQL - Backup Database
- SQL Table
- SQL - Create Table
- SQL - Show Tables
- SQL - Rename Table
- SQL - Truncate Table
- SQL - Clone Tables
- SQL - Temporary Tables
- SQL - Alter Tables
- SQL - Drop Table
- SQL - Delete Table
- SQL - Constraints
- SQL Queries
- SQL - Insert Query
- SQL - Select Query
- SQL - Select Into
- SQL - Insert Into Select
- SQL - Update Query
- SQL - Delete Query
- SQL - Sorting Results
- SQL Views
- SQL - Create Views
- SQL - Update Views
- SQL - Drop Views
- SQL - Rename Views
- SQL Operators and Clauses
- SQL - Where Clause
- SQL - Top Clause
- SQL - Distinct Clause
- SQL - Order By Clause
- SQL - Group By Clause
- SQL - Having Clause
- SQL - AND & OR
- SQL - BOOLEAN (BIT) Operator
- SQL - LIKE Operator
- SQL - IN Operator
- SQL - ANY, ALL Operators
- SQL - EXISTS Operator
- SQL - CASE
- SQL - NOT Operator
- SQL - NOT EQUAL
- SQL - IS NULL
- SQL - IS NOT NULL
- SQL - NOT NULL
- SQL - BETWEEN Operator
- SQL - UNION Operator
- SQL - UNION vs UNION ALL
- SQL - INTERSECT Operator
- SQL - EXCEPT Operator
- SQL - Aliases
- SQL Joins
- SQL - Using Joins
- SQL - Inner Join
- SQL - Left Join
- SQL - Right Join
- SQL - Cross Join
- SQL - Full Join
- SQL - Self Join
- SQL - Delete Join
- SQL - Update Join
- SQL - Left Join vs Right Join
- SQL - Union vs Join
- SQL Keys
- SQL - Unique Key
- SQL - Primary Key
- SQL - Foreign Key
- SQL - Composite Key
- SQL - Alternate Key
- SQL Indexes
- SQL - Indexes
- SQL - Create Index
- SQL - Drop Index
- SQL - Show Indexes
- SQL - Unique Index
- SQL - Clustered Index
- SQL - Non-Clustered Index
- Advanced SQL
- SQL - Wildcards
- SQL - Injection
- SQL - Hosting
- SQL - Min & Max
- SQL - Null Functions
- SQL - Check Constraint
- SQL - Default Constraint
- SQL - Stored Procedures
- SQL - NULL Values
- SQL - Transactions
- SQL - Sub Queries
- SQL - Handling Duplicates
- SQL - Using Sequences
- SQL - Auto Increment
- SQL - Date & Time
- SQL - Cursors
- SQL - Common Table Expression
- SQL - Group By vs Order By
- SQL - IN vs EXISTS
- SQL - Database Tuning
- SQL Function Reference
- SQL - Date Functions
- SQL - String Functions
- SQL - Aggregate Functions
- SQL - Numeric Functions
- SQL - Text & Image Functions
- SQL - Statistical Functions
- SQL - Logical Functions
- SQL - Cursor Functions
- SQL - JSON Functions
- SQL - Conversion Functions
- SQL - Datatype Functions
- SQL Useful Resources
- SQL - Questions and Answers
- SQL - Cheatsheet
- SQL - Quick Guide
- SQL - Useful Functions
- SQL - Useful Resources
- SQL - Discussion
SQL - Comments
SQL Comments
SQL comments are notes you can add inside your SQL code to explain what the code does. The database ignores these comments when running queries, but they help developers read, understand, and maintain the code. Comments are also useful for temporarily disabling parts of a query without deleting them.
Types of SQL Comments
SQL supports three main types of comments:
- Single-line comments: These comments are used for one line of text. Start the comment with --. Everything after -- on that line is ignored by the database.
- Multi-line comments: These comments are used for longer explanations across multiple lines. They are enclosed between /* and */.
- Inline comments: These comments are placed at the end of a SQL statement or line of code to add a brief explanation.
SQL Single Line Comments
The SQL single line comments are used to write short notes for a single line of SQL code. Everything written after -- on the same line is ignored by the database engine. These comments are ideal for briefly explaining a query or temporarily disabling a single line.
Syntax
Following is the syntax of SQL single line comment:
-- This is a single line comment
Example
In the following query, we are using a single line comment to write a text:
-- Will fetch all the table records SELECT * from table;
SQL Multi-Line Comments
The SQL multi line comments are used to comment out multiple lines or a block of SQL code. It starts with /* and ends with */. Entire text between these delimiters (/*...*/) will be ignored and considered as a comment.
Syntax
Following is the syntax of SQL multi line comments:
/* This is a multi-line comment */
Example
The following example uses multi-line comment as an explanation of the query:
/*following query will fetch all the table records./* SELECT * from CUSTOMERS;
SQL Inline Comments
The SQL inline comments are written at the end of a SQL statement or code line. They are used to quickly explain what a specific part of the query does, without affecting how the query runs. Inline comments are useful when you want to give a short clarification right next to the code.
Syntax
Following is the syntax of SQL inline comment:
SELECT column_name -- This is an inline comment FROM table_name;
Example
The following example shows how to use an inline comment to explain each part of a query:
SELECT id, name, salary -- Fetch employee id, name, and salary FROM employees WHERE salary > 50000; -- Only include employees with salary greater than 50,000