Warning, file /frameworks/syntax-highlighting/autotests/input/test.sql was not indexed or was modified since last indexation (in which case cross-reference links may be missing, inaccurate or erroneous).
0001 -- comment 0002 0003 CREATE TABLE stuff COLUMNS(col1 INT, col2 Varchar); 0004 SELECT * FROM stuff WHERE id = 'string'; 0005 select * from stuff where id < 0.42; 0006 Select col1, col2 From stuff Where stuff.col1 IS NOT NuLL; 0007 0008 CREATE TABLE Persons ( 0009 ID int NOT NULL AUTO_INCREMENT, 0010 LastName varchar(255) NOT NULL, 0011 FirstName varchar(255), 0012 Age int, 0013 PRIMARY KEY (ID) 0014 CONSTRAINT CHK_Person CHECK (Age>=18 AND City='Sandnes') 0015 ); 0016 0017 SELECT column_name(s) 0018 FROM table1 0019 FULL OUTER JOIN table2 ON table1.column_name = table2.column_name; 0020 0021 SELECT * FROM Customers 0022 WHERE City LIKE '[bsp]%'; 0023 0024 SELECT Count(*) AS DistinctCountries 0025 FROM (SELECT DISTINCT Country FROM Customers) 0026 GROUP BY Country 0027 HAVING COUNT(CustomerID) > 5 0028 ORDER BY COUNT(CustomerID) DESC; 0029 0030 SELECT 'Customer' As Type, ContactName, City, Country 0031 FROM Customers 0032 UNION 0033 SELECT 'Supplier', ContactName, City, Country 0034 FROM Suppliers; 0035 0036 SELECT COUNT(ProductID), AVG(Price) 0037 FROM Products; 0038 0039 SET lock_timeout = 0; 0040 SET client_encoding = 'UTF8'; 0041 SET standard_conforming_strings = on; 0042 SET check_function_bodies = false; 0043 SET client_min_messages = warning; 0044 SET default_tablespace = ''; 0045 0046 DROP TABLE IF EXISTS employees; 0047 0048 ALTER TABLE ONLY employees 0049 ADD CONSTRAINT fk_employees_employees FOREIGN KEY (reportsto) REFERENCES employees; 0050 0051 CREATE VIEW [Current Product List] AS 0052 SELECT ProductID, ProductName 0053 FROM Products 0054 WHERE Discontinued = No; 0055 0056 SELECT * FROM [Current Product List]; 0057 0058 SELECT * FROM [Category Sales For 1997] 0059 WHERE CategoryName = 'Beverages'; 0060 0061 begin 0062 end 0063 / 0064 / 0065 / u 0066 0067 /* nested /* comments */ for */ PostgreSQL