Debian Codegraph @

www/syntax/select-core.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="../sqlite.css" rel="stylesheet">
6 <title>SQLite Syntax: select-core</title>
7 <!-- path=../ -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="../index.html">
12 <img class="logo" src="../images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="../index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='../about.html'>About</a>
23 <li class='desktoponly'><a href="../docs.html">Documentation</a>
24 <li class='desktoponly'><a href="../download.html">Download</a>
25 <li class='wideonly'><a href='../copyright.html'>License</a>
26 <li class='desktoponly'><a href="../support.html">Support</a>
27 <li class='desktoponly'><a href="../prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='../about.html'>About</a>
35 <li><a href='../docs.html'>Documentation</a>
36 <li><a href='../download.html'>Download</a>
37 <li><a href='../support.html'>Support</a>
38 <li><a href='../prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="../search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118 <h1 align='center'>select-core</h1>
119 <div class='imgcontainer'>
120 <div style="max-width:655px"><svg xmlns='http://www.w3.org/2000/svg' style='font-size:initial;' class="pikchr" viewBox="0 0 655.157 728.568" data-pikchr-date="20250319161943">
121 <circle cx="5.76" cy="17.28" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
122 <polygon points="63.36,17.28 51.84,21.6 51.84,12.96" style="fill:rgb(0,0,0)"/>
123 <path d="M9.36,17.28L57.6,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
124 <path d="M78.48,32.4L129.686,32.4A15.12 15.12 0 0 0 144.806 17.28A15.12 15.12 0 0 0 129.686 2.16L78.48,2.16A15.12 15.12 0 0 0 63.36 17.28A15.12 15.12 0 0 0 78.48 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
125 <text x="104.083" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">SELECT</text>
126 <polygon points="186.326,47.52 174.806,51.84 174.806,43.2" style="fill:rgb(0,0,0)"/>
127 <path d="M144.806,17.28 L 152.306,17.28 Q 159.806,17.28 159.806,32.28 L 159.806,32.52 Q 159.806,47.52 170.186,47.52 L 180.566,47.52" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
128 <path d="M201.446,62.64L269.702,62.64A15.12 15.12 0 0 0 284.822 47.52L284.822,47.52A15.12 15.12 0 0 0 269.702 32.4L201.446,32.4A15.12 15.12 0 0 0 186.326 47.52L186.326,47.52A15.12 15.12 0 0 0 201.446 62.64Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
129 <text x="235.574" y="47.52" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">DISTINCT</text>
130 <polygon points="353.822,17.28 342.302,21.6 342.302,12.96" style="fill:rgb(0,0,0)"/>
131 <path d="M284.822,47.52 L 292.322,47.52 Q 299.822,47.52 299.822,32.52 L 299.822,32.28 Q 299.822,17.28 314.822,17.28 L 333.062,17.28 L 348.062,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
132 <path d="M353.822,32.4L481.464,32.4L481.464,2.16L353.822,2.16Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
133 <text x="417.643" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">result-column</text>
134 <path d="M417.643,70.2A15.12 15.12 0 0 0 432.763 55.08L432.763,55.08A15.12 15.12 0 0 0 417.643 39.96A15.12 15.12 0 0 0 402.523 55.08L402.523,55.08A15.12 15.12 0 0 0 417.643 70.2Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
135 <text x="417.643" y="55.08" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
136 <polygon points="432.763,55.08 444.283,50.76 444.283,59.4" style="fill:rgb(0,0,0)"/>
137 <path d="M481.464,17.28 L 488.964,17.28 Q 496.464,17.28 496.464,32.28 L 496.464,40.08 Q 496.464,55.08 481.464,55.08 L 453.523,55.08 L 438.523,55.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
138 <path d="M402.523,55.08 L 342.302,55.08 Q 327.302,55.08 327.302,40.08 L 327.302,32.28 Q 327.302,17.28 334.802,17.28 L 342.302,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
139 <polygon points="235.574,17.28 224.054,21.6 224.054,12.96" style="fill:rgb(0,0,0)"/>
140 <path d="M144.806,17.28L229.814,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
141 <path d="M235.574,17.28L342.302,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
142 <path d="M201.446,100.44L216.365,100.44A15.12 15.12 0 0 0 231.485 85.32A15.12 15.12 0 0 0 216.365 70.2L201.446,70.2A15.12 15.12 0 0 0 186.326 85.32A15.12 15.12 0 0 0 201.446 100.44Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
143 <text x="208.906" y="85.32" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ALL</text>
144 <polygon points="284.822,85.32 273.302,89.64 273.302,81" style="fill:rgb(0,0,0)"/>
145 <path d="M231.485,85.32L279.062,85.32" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
146 <path d="M284.822,85.32 L 292.322,85.32 Q 299.822,85.32 299.822,70.32 L 299.822,47.4 L 299.822,32.4" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
147 <polygon points="186.326,85.32 174.806,89.64 174.806,81" style="fill:rgb(0,0,0)"/>
148 <path d="M144.806,17.28 L 152.306,17.28 Q 159.806,17.28 159.806,32.28 L 159.806,70.32 Q 159.806,85.32 170.186,85.32 L 180.566,85.32" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
149 <path d="M105,176.04L139.848,176.04A15.12 15.12 0 0 0 154.968 160.92A15.12 15.12 0 0 0 139.848 145.8L105,145.8A15.12 15.12 0 0 0 89.88 160.92A15.12 15.12 0 0 0 105 176.04Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
150 <text x="122.424" y="160.92" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">FROM</text>
151 <polygon points="226.968,160.92 215.448,165.24 215.448,156.6" style="fill:rgb(0,0,0)"/>
152 <path d="M154.968,160.92L221.208,160.92" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
153 <path d="M226.968,176.04L387.902,176.04L387.902,145.8L226.968,145.8Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
154 <text x="307.435" y="160.92" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-or-subquery</text>
155 <path d="M256.402,250.128L358.469,250.128L358.469,219.888L256.402,219.888Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
156 <text x="307.435" y="235.008" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">join-clause</text>
157 <path d="M307.435,212.328A15.12 15.12 0 0 0 322.555 197.208A15.12 15.12 0 0 0 307.435 182.088A15.12 15.12 0 0 0 292.315 197.208A15.12 15.12 0 0 0 307.435 212.328Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
158 <text x="307.435" y="197.208" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
159 <polygon points="322.555,197.208 334.075,192.888 334.075,201.528" style="fill:rgb(0,0,0)"/>
160 <path d="M387.902,160.92 L 395.402,160.92 Q 402.902,160.92 402.902,175.92 L 402.902,182.208 Q 402.902,197.208 387.902,197.208 L 343.315,197.208 L 328.315,197.208" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
161 <path d="M292.315,197.208 L 215.448,197.208 Q 200.448,197.208 200.448,182.208 L 200.448,175.92 Q 200.448,160.92 207.948,160.92 L 215.448,160.92" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
162 <polygon points="256.402,235.008 244.882,239.328 244.882,230.688" style="fill:rgb(0,0,0)"/>
163 <path d="M154.968,160.92 L 162.468,160.92 Q 169.968,160.92 169.968,175.92 L 169.968,220.008 Q 169.968,235.008 184.968,235.008 L 235.642,235.008 L 250.642,235.008" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
164 <polygon points="420.902,201.744 425.222,213.264 416.582,213.264" style="fill:rgb(0,0,0)"/>
165 <path d="M358.469,235.008 L 373.186,235.008 Q 387.902,235.008 402.902,235.008 L 405.902,235.008 Q 420.902,235.008 420.902,221.256 L 420.902,207.504" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
166 <polygon points="441.902,160.92 430.382,165.24 430.382,156.6" style="fill:rgb(0,0,0)"/>
167 <path d="M420.902,201.744 L 420.902,175.92 Q 420.902,160.92 428.522,160.92 L 436.142,160.92" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
168 <path d="M441.902,160.92 L 432.902,160.92 Q 423.902,160.92 423.902,160.92 Q 423.902,160.92 431.402,160.92 L 438.902,160.92" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
169 <polygon points="496.464,85.32 492.144,73.8 500.784,73.8" style="fill:rgb(0,0,0)"/>
170 <path d="M481.464,17.28 L 488.964,17.28 Q 496.464,17.28 496.464,32.28 L 496.464,64.56 L 496.464,79.56" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
171 <polygon points="284.822,123.12 296.342,118.8 296.342,127.44" style="fill:rgb(0,0,0)"/>
172 <path d="M496.464,85.32 L 496.464,108.12 Q 496.464,123.12 481.464,123.12 L 305.582,123.12 L 290.582,123.12" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
173 <polygon points="89.88,160.92 78.36,165.24 78.36,156.6" style="fill:rgb(0,0,0)"/>
174 <path d="M284.822,123.12 L 78.36,123.12 Q 63.36,123.12 63.36,138.12 L 63.36,145.92 Q 63.36,160.92 73.74,160.92 L 84.12,160.92" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
175 <path d="M105,325.728L154.478,325.728A15.12 15.12 0 0 0 169.598 310.608A15.12 15.12 0 0 0 154.478 295.488L105,295.488A15.12 15.12 0 0 0 89.88 310.608A15.12 15.12 0 0 0 105 325.728Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
176 <text x="129.739" y="310.608" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">WHERE</text>
177 <polygon points="192.638,310.608 181.118,314.928 181.118,306.288" style="fill:rgb(0,0,0)"/>
178 <path d="M169.598,310.608L186.878,310.608" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
179 <path d="M192.638,325.728L241.829,325.728L241.829,295.488L192.638,295.488Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
180 <text x="217.234" y="310.608" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text>
181 <polygon points="453.902,212.328 449.582,200.808 458.222,200.808" style="fill:rgb(0,0,0)"/>
182 <path d="M387.902,160.92 L 438.902,160.92 Q 453.902,160.92 453.902,175.92 L 453.902,191.568 L 453.902,206.568" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
183 <polygon points="307.435,272.808 318.955,268.488 318.955,277.128" style="fill:rgb(0,0,0)"/>
184 <path d="M453.902,212.328 L 453.902,257.808 Q 453.902,272.808 438.902,272.808 L 328.195,272.808 L 313.195,272.808" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
185 <polygon points="89.88,310.608 78.36,314.928 78.36,306.288" style="fill:rgb(0,0,0)"/>
186 <path d="M307.435,272.808 L 78.36,272.808 Q 63.36,272.808 63.36,287.808 L 63.36,295.608 Q 63.36,310.608 73.74,310.608 L 84.12,310.608" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
187 <polygon points="63.36,212.328 59.04,200.808 67.68,200.808" style="fill:rgb(0,0,0)"/>
188 <path d="M63.36,145.8L63.36,206.568" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
189 <path d="M63.36,212.328L63.36,295.488" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
190 <path d="M105,424.008L148.488,424.008A15.12 15.12 0 0 0 163.608 408.888A15.12 15.12 0 0 0 148.488 393.768L105,393.768A15.12 15.12 0 0 0 89.88 408.888A15.12 15.12 0 0 0 105 424.008Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
191 <text x="126.744" y="408.888" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">GROUP</text>
192 <polygon points="186.648,408.888 175.128,413.208 175.128,404.568" style="fill:rgb(0,0,0)"/>
193 <path d="M163.608,408.888L180.888,408.888" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
194 <path d="M201.768,424.008L205.858,424.008A15.12 15.12 0 0 0 220.978 408.888A15.12 15.12 0 0 0 205.858 393.768L201.768,393.768A15.12 15.12 0 0 0 186.648 408.888A15.12 15.12 0 0 0 201.768 424.008Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
195 <text x="203.813" y="408.888" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">BY</text>
196 <polygon points="256.978,408.888 245.458,413.208 245.458,404.568" style="fill:rgb(0,0,0)"/>
197 <path d="M220.978,408.888L251.218,408.888" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
198 <path d="M256.978,424.008L306.168,424.008L306.168,393.768L256.978,393.768Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
199 <text x="281.573" y="408.888" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text>
200 <polygon points="388.968,408.888 377.448,413.208 377.448,404.568" style="fill:rgb(0,0,0)"/>
201 <path d="M306.168,408.888L383.208,408.888" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
202 <path d="M404.088,424.008L456.446,424.008A15.12 15.12 0 0 0 471.566 408.888A15.12 15.12 0 0 0 456.446 393.768L404.088,393.768A15.12 15.12 0 0 0 388.968 408.888A15.12 15.12 0 0 0 404.088 424.008Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
203 <text x="430.267" y="408.888" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">HAVING</text>
204 <polygon points="494.606,408.888 483.086,413.208 483.086,404.568" style="fill:rgb(0,0,0)"/>
205 <path d="M471.566,408.888L488.846,408.888" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
206 <path d="M494.606,424.008L543.797,424.008L543.797,393.768L494.606,393.768Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
207 <text x="519.202" y="408.888" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text>
208 <path d="M281.573,461.808A15.12 15.12 0 0 0 296.693 446.688A15.12 15.12 0 0 0 281.573 431.568A15.12 15.12 0 0 0 266.453 446.688A15.12 15.12 0 0 0 281.573 461.808Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
209 <text x="281.573" y="446.688" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
210 <polygon points="296.693,446.688 308.213,442.368 308.213,451.008" style="fill:rgb(0,0,0)"/>
211 <path d="M306.168,408.888 L 313.668,408.888 Q 321.168,408.888 321.168,423.888 L 321.168,431.688 Q 321.168,446.688 311.81,446.688 L 302.453,446.688" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
212 <path d="M266.453,446.688 L 245.458,446.688 Q 230.458,446.688 230.458,431.688 L 230.458,423.888 Q 230.458,408.888 237.958,408.888 L 245.458,408.888" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
213 <polygon points="450.917,439.128 439.397,443.448 439.397,434.808" style="fill:rgb(0,0,0)"/>
214 <path d="M347.448,408.888 L 354.948,408.888 Q 362.448,408.888 362.448,423.888 L 362.448,424.128 Q 362.448,439.128 377.448,439.128 L 430.157,439.128 L 445.157,439.128" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
215 <path d="M450.917,439.128 L 543.797,439.128 Q 558.797,439.128 558.797,424.128 L 558.797,423.888 Q 558.797,408.888 566.297,408.888 L 573.797,408.888" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
216 <polygon points="203.813,378.648 192.293,382.968 192.293,374.328" style="fill:rgb(0,0,0)"/>
217 <path d="M63.36,348.408 L 63.36,363.648 Q 63.36,378.648 78.36,378.648 L 183.053,378.648 L 198.053,378.648" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
218 <polygon points="347.688,408.888 336.168,413.208 336.168,404.568" style="fill:rgb(0,0,0)"/>
219 <path d="M203.813,378.648 L 306.168,378.648 Q 321.168,378.648 321.168,393.648 L 321.168,393.888 Q 321.168,408.888 331.548,408.888 L 341.928,408.888" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
220 <polygon points="169.598,348.408 181.118,344.088 181.118,352.728" style="fill:rgb(0,0,0)"/>
221 <path d="M241.829,310.608 L 249.329,310.608 Q 256.829,310.608 256.829,325.608 L 256.829,333.408 Q 256.829,348.408 241.829,348.408 L 190.358,348.408 L 175.358,348.408" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
222 <polygon points="89.88,408.888 78.36,413.208 78.36,404.568" style="fill:rgb(0,0,0)"/>
223 <path d="M169.598,348.408 L 78.36,348.408 Q 63.36,348.408 63.36,363.408 L 63.36,393.888 Q 63.36,408.888 73.74,408.888 L 84.12,408.888" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
224 <polygon points="63.36,335.268 59.04,323.748 67.68,323.748" style="fill:rgb(0,0,0)"/>
225 <path d="M63.36,295.488L63.36,329.508" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
226 <path d="M63.36,335.268L63.36,393.768" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
227 <path d="M105,537.408L168.418,537.408A15.12 15.12 0 0 0 183.538 522.288A15.12 15.12 0 0 0 168.418 507.168L105,507.168A15.12 15.12 0 0 0 89.88 522.288A15.12 15.12 0 0 0 105 537.408Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
228 <text x="136.709" y="522.288" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">WINDOW</text>
229 <polygon points="219.538,522.288 208.018,526.608 208.018,517.968" style="fill:rgb(0,0,0)"/>
230 <path d="M183.538,522.288L213.778,522.288" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
231 <path d="M234.658,537.408L331.714,537.408A15.12 15.12 0 0 0 346.834 522.288A15.12 15.12 0 0 0 331.714 507.168L234.658,507.168A15.12 15.12 0 0 0 219.538 522.288A15.12 15.12 0 0 0 234.658 537.408Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
232 <text x="283.186" y="522.288" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">window-name</text>
233 <polygon points="369.874,522.288 358.354,526.608 358.354,517.968" style="fill:rgb(0,0,0)"/>
234 <path d="M346.834,522.288L364.114,522.288" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
235 <path d="M384.994,537.408L388.968,537.408A15.12 15.12 0 0 0 404.088 522.288A15.12 15.12 0 0 0 388.968 507.168L384.994,507.168A15.12 15.12 0 0 0 369.874 522.288A15.12 15.12 0 0 0 384.994 537.408Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
236 <text x="386.981" y="522.288" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">AS</text>
237 <polygon points="427.128,522.288 415.608,526.608 415.608,517.968" style="fill:rgb(0,0,0)"/>
238 <path d="M404.088,522.288L421.368,522.288" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
239 <path d="M427.128,537.408L545.554,537.408L545.554,507.168L427.128,507.168Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
240 <text x="486.341" y="522.288" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">window-defn</text>
241 <path d="M382.546,575.208A15.12 15.12 0 0 0 397.666 560.088A15.12 15.12 0 0 0 382.546 544.968A15.12 15.12 0 0 0 367.426 560.088A15.12 15.12 0 0 0 382.546 575.208Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
242 <text x="382.546" y="560.088" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
243 <polygon points="397.666,560.088 409.186,555.768 409.186,564.408" style="fill:rgb(0,0,0)"/>
244 <path d="M545.554,522.288 L 553.054,522.288 Q 560.554,522.288 560.554,537.288 L 560.554,545.088 Q 560.554,560.088 545.554,560.088 L 418.426,560.088 L 403.426,560.088" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
245 <path d="M367.426,560.088 L 208.018,560.088 Q 193.018,560.088 193.018,545.088 L 193.018,537.288 Q 193.018,522.288 200.518,522.288 L 208.018,522.288" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
246 <polygon points="588.797,446.688 584.477,435.168 593.117,435.168" style="fill:rgb(0,0,0)"/>
247 <path d="M543.797,408.888 L 573.797,408.888 Q 588.797,408.888 588.797,423.888 L 588.797,425.928 L 588.797,440.928" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
248 <polygon points="307.435,484.488 318.955,480.168 318.955,488.808" style="fill:rgb(0,0,0)"/>
249 <path d="M588.797,446.688 L 588.797,469.488 Q 588.797,484.488 573.797,484.488 L 328.195,484.488 L 313.195,484.488" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
250 <polygon points="89.88,522.288 78.36,526.608 78.36,517.968" style="fill:rgb(0,0,0)"/>
251 <path d="M307.435,484.488 L 78.36,484.488 Q 63.36,484.488 63.36,499.488 L 63.36,507.288 Q 63.36,522.288 73.74,522.288 L 84.12,522.288" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
252 <polygon points="63.36,446.688 59.04,435.168 67.68,435.168" style="fill:rgb(0,0,0)"/>
253 <path d="M63.36,393.768L63.36,440.928" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
254 <polygon points="307.435,597.888 295.915,602.208 295.915,593.568" style="fill:rgb(0,0,0)"/>
255 <path d="M63.36,446.688 L 63.36,582.888 Q 63.36,597.888 78.36,597.888 L 286.675,597.888 L 301.675,597.888" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
256 <polygon points="645.797,597.888 634.277,602.208 634.277,593.568" style="fill:rgb(0,0,0)"/>
257 <path d="M307.435,597.888L640.037,597.888" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
258 <circle cx="649.397" cy="597.888" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
259 <polygon points="560.554,586.368 556.234,574.848 564.874,574.848" style="fill:rgb(0,0,0)"/>
260 <path d="M560.554,544.968L560.554,580.608" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
261 <path d="M560.554,586.368 L 560.554,592.128 Q 560.554,597.888 568.054,597.888 L 575.554,597.888" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
262 <path d="M78.48,688.608L130.838,688.608A15.12 15.12 0 0 0 145.958 673.488A15.12 15.12 0 0 0 130.838 658.368L78.48,658.368A15.12 15.12 0 0 0 63.36 673.488A15.12 15.12 0 0 0 78.48 688.608Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
263 <text x="104.659" y="673.488" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">VALUES</text>
264 <polygon points="181.958,673.488 170.438,677.808 170.438,669.168" style="fill:rgb(0,0,0)"/>
265 <path d="M145.958,673.488L176.198,673.488" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
266 <path d="M197.078,688.608A15.12 15.12 0 0 0 212.198 673.488A15.12 15.12 0 0 0 197.078 658.368A15.12 15.12 0 0 0 181.958 673.488A15.12 15.12 0 0 0 197.078 688.608Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
267 <text x="197.078" y="673.488" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">(</text>
268 <polygon points="248.198,673.488 236.678,677.808 236.678,669.168" style="fill:rgb(0,0,0)"/>
269 <path d="M212.198,673.488L242.438,673.488" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
270 <path d="M248.198,688.608L297.389,688.608L297.389,658.368L248.198,658.368Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
271 <text x="272.794" y="673.488" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text>
272 <polygon points="333.389,673.488 321.869,677.808 321.869,669.168" style="fill:rgb(0,0,0)"/>
273 <path d="M297.389,673.488L327.629,673.488" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
274 <path d="M348.509,688.608A15.12 15.12 0 0 0 363.629 673.488A15.12 15.12 0 0 0 348.509 658.368A15.12 15.12 0 0 0 333.389 673.488A15.12 15.12 0 0 0 348.509 688.608Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
275 <text x="348.509" y="673.488" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">)</text>
276 <polygon points="573.797,673.488 562.277,677.808 562.277,669.168" style="fill:rgb(0,0,0)"/>
277 <path d="M363.629,673.488L568.037,673.488" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
278 <polygon points="588.797,612.888 593.117,624.408 584.477,624.408" style="fill:rgb(0,0,0)"/>
279 <path d="M573.797,673.488 L 581.297,673.488 Q 588.797,673.488 588.797,658.488 L 588.797,633.648 L 588.797,618.648" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
280 <path d="M588.797,612.888 L 588.797,605.388 Q 588.797,597.888 603.797,597.888 L 609.797,597.888 L 624.797,597.888" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
281 <path d="M272.794,650.808A15.12 15.12 0 0 0 287.914 635.688A15.12 15.12 0 0 0 272.794 620.568A15.12 15.12 0 0 0 257.674 635.688A15.12 15.12 0 0 0 272.794 650.808Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
282 <text x="272.794" y="635.688" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
283 <path d="M272.794,726.408A15.12 15.12 0 0 0 287.914 711.288A15.12 15.12 0 0 0 272.794 696.168A15.12 15.12 0 0 0 257.674 711.288A15.12 15.12 0 0 0 272.794 726.408Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
284 <text x="272.794" y="711.288" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
285 <polygon points="287.914,635.688 299.434,631.368 299.434,640.008" style="fill:rgb(0,0,0)"/>
286 <path d="M297.389,673.488 L 304.889,673.488 Q 312.389,673.488 312.389,658.488 L 312.389,650.688 Q 312.389,635.688 303.031,635.688 L 293.674,635.688" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
287 <path d="M257.674,635.688 L 236.678,635.688 Q 221.678,635.688 221.678,650.688 L 221.678,658.488 Q 221.678,673.488 229.178,673.488 L 236.678,673.488" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
288 <polygon points="287.914,711.288 299.434,706.968 299.434,715.608" style="fill:rgb(0,0,0)"/>
289 <path d="M363.629,673.488 L 371.129,673.488 Q 378.629,673.488 378.629,688.488 L 378.629,696.288 Q 378.629,711.288 363.629,711.288 L 308.674,711.288 L 293.674,711.288" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
290 <path d="M257.674,711.288 L 170.438,711.288 Q 155.438,711.288 155.438,696.288 L 155.438,688.488 Q 155.438,673.488 162.938,673.488 L 170.438,673.488" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
291 <polygon points="63.36,673.488 51.84,677.808 51.84,669.168" style="fill:rgb(0,0,0)"/>
292 <path d="M9.36,17.28 L 16.86,17.28 Q 24.36,17.28 24.36,32.28 L 24.36,658.488 Q 24.36,673.488 39.36,673.488 L 42.6,673.488 L 57.6,673.488" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
293 </svg>
294 </div><br>
295
296 Used by:&nbsp;&nbsp; <a href='./compound-select-stmt.html'>compound-select-stmt</a>&nbsp;&nbsp; <a href='./factored-select-stmt.html'>factored-select-stmt</a>&nbsp;&nbsp; <a href='./simple-select-stmt.html'>simple-select-stmt</a><br></br>
297 References:&nbsp;&nbsp; <a href='./expr.html'>expr</a>&nbsp;&nbsp; <a href='./join-clause.html'>join-clause</a>&nbsp;&nbsp; <a href='./result-column.html'>result-column</a>&nbsp;&nbsp; <a href='./table-or-subquery.html'>table-or-subquery</a>&nbsp;&nbsp; <a href='./window-defn.html'>window-defn</a><br></br>
298 See also:&nbsp;&nbsp; <a href='../lang_select.html'>lang_select.html</a>
299 </div>
300
301
302