COMMENTS


在 SQL 中,我們可以加上註解以增加可讀性。

單一註解:

--Select all:
SELECT * FROM Customers;

or

#Select all:
SELECT * FROM Customers;

多行註解:

SELECT * FROM Customers WHERE (CustomerName LIKE 'L%'
OR CustomerName LIKE 'R%' /*OR CustomerName LIKE 'S%'
OR CustomerName LIKE 'T%'*/ OR CustomerName LIKE 'W%')
AND Country='USA'
ORDER BY CustomerName;

or

/*Select all the columns
of all the records
in the Customers table:*/
SELECT * FROM Customers;

results matching ""

    No results matching ""