1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
|
<!DOCTYPE html>
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<title>test.sql</title>
<meta name="generator" content="KF5::SyntaxHighlighting - Definition (SQL) - Theme (Breeze Dark)"/>
</head><body style="background-color:#232629;color:#cfcfc2"><pre>
<span style="color:#7a7c7d">-- comment</span>
<span style="font-weight:bold">CREATE</span> <span style="font-weight:bold">TABLE</span> stuff <span style="font-weight:bold">COLUMNS</span>(col1 <span style="color:#2980b9">INT</span>, col2 <span style="color:#2980b9">Varchar</span>);
<span style="font-weight:bold">SELECT</span> <span style="color:#3f8058">*</span> <span style="font-weight:bold">FROM</span> stuff <span style="font-weight:bold">WHERE</span> <span style="font-weight:bold">id</span> <span style="color:#3f8058">=</span> <span style="color:#f44f4f">'string'</span>;
<span style="font-weight:bold">select</span> <span style="color:#3f8058">*</span> <span style="font-weight:bold">from</span> stuff <span style="font-weight:bold">where</span> <span style="font-weight:bold">id</span> <span style="color:#3f8058"><</span> <span style="color:#f67400">0.42</span>;
<span style="font-weight:bold">Select</span> col1, col2 <span style="font-weight:bold">From</span> stuff <span style="font-weight:bold">Where</span> stuff.col1 <span style="font-weight:bold">IS</span> <span style="font-weight:bold">NOT</span> <span style="font-weight:bold">NuLL</span>;
<span style="font-weight:bold">CREATE</span> <span style="font-weight:bold">TABLE</span> Persons (
<span style="font-weight:bold">ID</span> <span style="color:#2980b9">int</span> <span style="font-weight:bold">NOT</span> <span style="font-weight:bold">NULL</span> AUTO_INCREMENT,
LastName <span style="color:#2980b9">varchar</span>(<span style="color:#f67400">255</span>) <span style="font-weight:bold">NOT</span> <span style="font-weight:bold">NULL</span>,
FirstName <span style="color:#2980b9">varchar</span>(<span style="color:#f67400">255</span>),
Age <span style="color:#2980b9">int</span>,
<span style="font-weight:bold">PRIMARY</span> <span style="font-weight:bold">KEY</span> (<span style="font-weight:bold">ID</span>)
<span style="font-weight:bold">CONSTRAINT</span> CHK_Person <span style="font-weight:bold">CHECK</span> (Age<span style="color:#3f8058">>=</span><span style="color:#f67400">18</span> <span style="font-weight:bold">AND</span> City<span style="color:#3f8058">=</span><span style="color:#f44f4f">'Sandnes'</span>)
);
<span style="font-weight:bold">SELECT</span> column_name(s)
<span style="font-weight:bold">FROM</span> table1
<span style="font-weight:bold">FULL</span> <span style="font-weight:bold">OUTER</span> <span style="font-weight:bold">JOIN</span> table2 <span style="font-weight:bold">ON</span> table1.column_name <span style="color:#3f8058">=</span> table2.column_name;
<span style="font-weight:bold">SELECT</span> <span style="color:#3f8058">*</span> <span style="font-weight:bold">FROM</span> Customers
<span style="font-weight:bold">WHERE</span> City <span style="font-weight:bold">LIKE</span> <span style="color:#f44f4f">'[bsp]%'</span>;
<span style="font-weight:bold">SELECT</span> <span style="color:#8e44ad">Count</span>(<span style="color:#3f8058">*</span>) <span style="font-weight:bold">AS</span> DistinctCountries
<span style="font-weight:bold">FROM</span> (<span style="font-weight:bold">SELECT</span> <span style="font-weight:bold">DISTINCT</span> Country <span style="font-weight:bold">FROM</span> Customers)
<span style="font-weight:bold">GROUP</span> <span style="font-weight:bold">BY</span> Country
<span style="font-weight:bold">HAVING</span> <span style="color:#8e44ad">COUNT</span>(CustomerID) <span style="color:#3f8058">></span> <span style="color:#f67400">5</span>
<span style="font-weight:bold">ORDER</span> <span style="font-weight:bold">BY</span> <span style="color:#8e44ad">COUNT</span>(CustomerID) <span style="font-weight:bold">DESC</span>;
<span style="font-weight:bold">SELECT</span> <span style="color:#f44f4f">'Customer'</span> <span style="font-weight:bold">As</span> <span style="font-weight:bold">Type</span>, ContactName, City, Country
<span style="font-weight:bold">FROM</span> Customers
<span style="font-weight:bold">UNION</span>
<span style="font-weight:bold">SELECT</span> <span style="color:#f44f4f">'Supplier'</span>, ContactName, City, Country
<span style="font-weight:bold">FROM</span> Suppliers;
<span style="font-weight:bold">SELECT</span> <span style="color:#8e44ad">COUNT</span>(ProductID), <span style="color:#8e44ad">AVG</span>(Price)
<span style="font-weight:bold">FROM</span> Products;
<span style="font-weight:bold">SET</span> lock_timeout <span style="color:#3f8058">=</span> <span style="color:#f67400">0</span>;
<span style="font-weight:bold">SET</span> client_encoding <span style="color:#3f8058">=</span> <span style="color:#f44f4f">'UTF8'</span>;
<span style="font-weight:bold">SET</span> standard_conforming_strings <span style="color:#3f8058">=</span> <span style="font-weight:bold">on</span>;
<span style="font-weight:bold">SET</span> check_function_bodies <span style="color:#3f8058">=</span> <span style="font-weight:bold">false</span>;
<span style="font-weight:bold">SET</span> client_min_messages <span style="color:#3f8058">=</span> warning;
<span style="font-weight:bold">SET</span> default_tablespace <span style="color:#3f8058">=</span> <span style="color:#f44f4f">''</span>;
<span style="font-weight:bold">DROP</span> <span style="font-weight:bold">TABLE</span> <span style="color:#fdbc4b;font-weight:bold">IF</span> <span style="font-weight:bold">EXISTS</span> employees;
<span style="font-weight:bold">ALTER</span> <span style="font-weight:bold">TABLE</span> <span style="font-weight:bold">ONLY</span> employees
<span style="font-weight:bold">ADD</span> <span style="font-weight:bold">CONSTRAINT</span> fk_employees_employees <span style="font-weight:bold">FOREIGN</span> <span style="font-weight:bold">KEY</span> (reportsto) <span style="font-weight:bold">REFERENCES</span> employees;
<span style="font-weight:bold">CREATE</span> <span style="font-weight:bold">VIEW</span> [<span style="font-weight:bold">Current</span> Product <span style="font-weight:bold">List</span>] <span style="font-weight:bold">AS</span>
<span style="font-weight:bold">SELECT</span> ProductID, ProductName
<span style="font-weight:bold">FROM</span> Products
<span style="font-weight:bold">WHERE</span> Discontinued <span style="color:#3f8058">=</span> <span style="font-weight:bold">No</span>;
<span style="font-weight:bold">SELECT</span> <span style="color:#3f8058">*</span> <span style="font-weight:bold">FROM</span> [<span style="font-weight:bold">Current</span> Product <span style="font-weight:bold">List</span>];
<span style="font-weight:bold">SELECT</span> <span style="color:#3f8058">*</span> <span style="font-weight:bold">FROM</span> [<span style="font-weight:bold">Category</span> Sales <span style="color:#fdbc4b;font-weight:bold">For</span> <span style="color:#f67400">1997</span>]
<span style="font-weight:bold">WHERE</span> CategoryName <span style="color:#3f8058">=</span> <span style="color:#f44f4f">'Beverages'</span>;
<span style="color:#fdbc4b;font-weight:bold">begin</span>
<span style="color:#fdbc4b;font-weight:bold">end</span>
<span style="color:#3daee9">/</span>
<span style="color:#3f8058">/</span>
<span style="color:#3f8058">/</span> u
<span style="color:#7a7c7d">/* nested /* comments */ for */</span> PostgreSQL
</pre></body></html>
|
