/* Multi-Line Comment */
-- Single-Line comment
-- test
Single line comments start with –- Any text after these 2 characters to the end of the line will be
ignored.
Multiline comments start with /* and end with */. They stretch across multiple lines until the
closing characters have been found.
-- My Select query
/*
This is my select query.
It grabs all rows of data from the users table
*/
SELECT *
FROM /* table name here */ Students;
Single line comments start with --
-- Single Line Comments
Multi-line comments start with /* and end with */.
/*Multi-line comments*/
--Select all:
SELECT * FROM Customers;
/* Multi-Line
comment
goes here */
-- Single-Line comment goes here
-- Fetching all records from the Students table
SELECT *
FROM Students;
-- Fetching all records from the Students table
SELECT *
FROM Students;
SELECT * -- selects all records
FROM Students; -- from the Students table
Code Example |
---|
:: |
:: |
:: |
Sql :: |
Sql :: |
:: |
:: |
:: |
:: |
:: |
:: |
:: |
:: |
:: |
:: |
:: |
:: |
:: |
:: |
:: |
:: |
:: |
Sql :: |
:: |
:: can i use alias in where clause |
:: |
Sql :: |
Sql :: |
:: |
:: |