| 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: <a href='./compound-select-stmt.html'>compound-select-stmt</a> <a href='./factored-select-stmt.html'>factored-select-stmt</a> <a href='./simple-select-stmt.html'>simple-select-stmt</a><br></br> |
| 297 |
References: <a href='./expr.html'>expr</a> <a href='./join-clause.html'>join-clause</a> <a href='./result-column.html'>result-column</a> <a href='./table-or-subquery.html'>table-or-subquery</a> <a href='./window-defn.html'>window-defn</a><br></br> |
| 298 |
See also: <a href='../lang_select.html'>lang_select.html</a> |
| 299 |
</div> |
| 300 |
|
| 301 |
|
| 302 |
|