diff options
Diffstat (limited to 'www/syntax/compound-select-stmt.html')
| -rw-r--r-- | www/syntax/compound-select-stmt.html | 263 |
1 files changed, 263 insertions, 0 deletions
diff --git a/www/syntax/compound-select-stmt.html b/www/syntax/compound-select-stmt.html new file mode 100644 index 0000000..943048b --- /dev/null +++ b/www/syntax/compound-select-stmt.html @@ -0,0 +1,263 @@ +<!DOCTYPE html> +<html><head> +<meta name="viewport" content="width=device-width, initial-scale=1.0"> +<meta http-equiv="content-type" content="text/html; charset=UTF-8"> +<link href="../sqlite.css" rel="stylesheet"> +<title>SQLite Syntax: compound-select-stmt</title> +<!-- path=../ --> +</head> +<body> +<div class=nosearch> +<a href="../index.html"> +<img class="logo" src="../images/sqlite370_banner.gif" alt="SQLite" border="0"> +</a> +<div><!-- IE hack to prevent disappearing logo --></div> +<div class="tagline desktoponly"> +Small. Fast. Reliable.<br>Choose any three. +</div> +<div class="menu mainmenu"> +<ul> +<li><a href="../index.html">Home</a> +<li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a> +<li class='wideonly'><a href='../about.html'>About</a> +<li class='desktoponly'><a href="../docs.html">Documentation</a> +<li class='desktoponly'><a href="../download.html">Download</a> +<li class='wideonly'><a href='../copyright.html'>License</a> +<li class='desktoponly'><a href="../support.html">Support</a> +<li class='desktoponly'><a href="../prosupport.html">Purchase</a> +<li class='search' id='search_menubutton'> +<a href="javascript:void(0)" onclick='toggle_search()'>Search</a> +</ul> +</div> +<div class="menu submenu" id="submenu"> +<ul> +<li><a href='../about.html'>About</a> +<li><a href='../docs.html'>Documentation</a> +<li><a href='../download.html'>Download</a> +<li><a href='../support.html'>Support</a> +<li><a href='../prosupport.html'>Purchase</a> +</ul> +</div> +<div class="searchmenu" id="searchmenu"> +<form method="GET" action="../search"> +<select name="s" id="searchtype"> +<option value="d">Search Documentation</option> +<option value="c">Search Changelog</option> +</select> +<input type="text" name="q" id="searchbox" value=""> +<input type="submit" value="Go"> +</form> +</div> +</div> +<script> +function toggle_div(nm) { +var w = document.getElementById(nm); +if( w.style.display=="block" ){ +w.style.display = "none"; +}else{ +w.style.display = "block"; +} +} +function toggle_search() { +var w = document.getElementById("searchmenu"); +if( w.style.display=="block" ){ +w.style.display = "none"; +} else { +w.style.display = "block"; +setTimeout(function(){ +document.getElementById("searchbox").focus() +}, 30); +} +} +function div_off(nm){document.getElementById(nm).style.display="none";} +window.onbeforeunload = function(e){div_off("submenu");} +/* Disable the Search feature if we are not operating from CGI, since */ +/* Search is accomplished using CGI and will not work without it. */ +if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){ +document.getElementById("search_menubutton").style.display = "none"; +} +/* Used by the Hide/Show button beside syntax diagrams, to toggle the */ +function hideorshow(btn,obj){ +var x = document.getElementById(obj); +var b = document.getElementById(btn); +if( x.style.display!='none' ){ +x.style.display = 'none'; +b.innerHTML='show'; +}else{ +x.style.display = ''; +b.innerHTML='hide'; +} +return false; +} +var antiRobot = 0; +function antiRobotGo(){ +if( antiRobot!=3 ) return; +antiRobot = 7; +var j = document.getElementById("mtimelink"); +if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href"); +} +function antiRobotDefense(){ +document.body.onmousedown=function(){ +antiRobot |= 2; +antiRobotGo(); +document.body.onmousedown=null; +} +document.body.onmousemove=function(){ +antiRobot |= 2; +antiRobotGo(); +document.body.onmousemove=null; +} +setTimeout(function(){ +antiRobot |= 1; +antiRobotGo(); +}, 100) +antiRobotGo(); +} +antiRobotDefense(); +</script> +<h1 align='center'>compound-select-stmt</h1> +<div class='imgcontainer'> +<div style="max-width:652px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 652.306 560.52"> +<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> +<path d="M9,17L26,17" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="68,17 56,21 56,12" style="fill:rgb(0,0,0)"/> +<path d="M32,17L62,17" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M83,32L114,32A15 15 0 0 0 129 17A15 15 0 0 0 114 2L83,2A15 15 0 0 0 68 17A15 15 0 0 0 83 32Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="98" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">WITH</text> +<path d="M189,62L275,62A15 15 0 0 0 290 47L290,47A15 15 0 0 0 275 32L189,32A15 15 0 0 0 174 47L174,47A15 15 0 0 0 189 62Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="232" y="47" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">RECURSIVE</text> +<polygon points="232,17 220,21 220,12" style="fill:rgb(0,0,0)"/> +<path d="M129,17L226,17" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="380,17 368,21 368,12" style="fill:rgb(0,0,0)"/> +<path d="M232,17L374,17" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M380,32L606,32L606,2L380,2Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="493" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">common-table-expression</text> +<polygon points="174,47 162,51 162,43" style="fill:rgb(0,0,0)"/> +<path d="M129,17 L 136,17 Q 144,17 144,32 L 144,32 Q 144,47 156,47 L 168,47" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="313,47 301,51 301,43" style="fill:rgb(0,0,0)"/> +<path d="M290,47L307,47" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M313,47 L 321,47 Q 328,47 328,32 L 328,32 Q 328,17 343,17 L 353,17 L 368,17" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M493,70A15 15 0 0 0 508 55L508,55A15 15 0 0 0 493 39A15 15 0 0 0 478 55L478,55A15 15 0 0 0 493 70Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="493" y="55" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text> +<polygon points="508,55 520,50 520,59" style="fill:rgb(0,0,0)"/> +<path d="M606,17 L 614,17 Q 621,17 621,32 L 621,40 Q 621,55 606,55 L 529,55 L 514,55" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M478,55 L 372,55 Q 357,55 357,40 L 357,32 Q 357,17 363,17 L 368,17" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M68,183L171,183L171,153L68,153Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="120" y="168" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">select-core</text> +<path d="M83,365L128,365A15 15 0 0 0 143 349A15 15 0 0 0 128 334L83,334A15 15 0 0 0 68 349A15 15 0 0 0 83 365Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="105" y="349" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ORDER</text> +<polygon points="166,349 154,354 154,345" style="fill:rgb(0,0,0)"/> +<path d="M143,349L160,349" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M181,365L185,365A15 15 0 0 0 200 349A15 15 0 0 0 185 334L181,334A15 15 0 0 0 166 349A15 15 0 0 0 181 365Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="183" y="349" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">BY</text> +<path d="M83,470L116,470A15 15 0 0 0 132 455A15 15 0 0 0 116 440L83,440A15 15 0 0 0 68 455A15 15 0 0 0 83 470Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="100" y="455" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">LIMIT</text> +<polygon points="155,455 143,460 143,451" style="fill:rgb(0,0,0)"/> +<path d="M132,455L149,455" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M155,470L204,470L204,440L155,440Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="179" y="455" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text> +<polygon points="68,168 56,172 56,164" style="fill:rgb(0,0,0)"/> +<path d="M32,17 L 39,17 Q 47,17 47,32 L 47,153 Q 47,168 55,168 L 62,168" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="335,92 346,88 346,97" style="fill:rgb(0,0,0)"/> +<path d="M606,17 L 627,17 Q 642,17 642,32 L 642,77 Q 642,92 627,92 L 356,92 L 341,92" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M335,92 L 62,92 Q 47,92 47,100 L 47,107" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="243,168 232,172 232,164" style="fill:rgb(0,0,0)"/> +<path d="M171,168L238,168" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M259,183L302,183A15 15 0 0 0 317 168A15 15 0 0 0 302 153L259,153A15 15 0 0 0 243 168A15 15 0 0 0 259 183Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="280" y="168" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">UNION</text> +<path d="M259,221L302,221A15 15 0 0 0 317 206A15 15 0 0 0 302 191L259,191A15 15 0 0 0 243 206A15 15 0 0 0 259 221Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="280" y="206" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">UNION</text> +<polygon points="340,206 329,210 329,201" style="fill:rgb(0,0,0)"/> +<path d="M317,206L335,206" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M355,221L370,221A15 15 0 0 0 386 206A15 15 0 0 0 370 191L355,191A15 15 0 0 0 340 206A15 15 0 0 0 355 221Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="363" y="206" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ALL</text> +<polygon points="409,206 397,210 397,201" style="fill:rgb(0,0,0)"/> +<path d="M386,206L403,206" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="447,168 435,172 435,164" style="fill:rgb(0,0,0)"/> +<path d="M409,206 L 416,206 Q 424,206 424,191 L 424,183 Q 424,168 432,168 L 441,168" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M447,183L550,183L550,153L447,153Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="498" y="168" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">select-core</text> +<path d="M259,259L343,259A15 15 0 0 0 359 244A15 15 0 0 0 343 228L259,228A15 15 0 0 0 243 244A15 15 0 0 0 259 259Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="301" y="244" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">INTERSECT</text> +<path d="M259,297L310,297A15 15 0 0 0 325 281A15 15 0 0 0 310 266L259,266A15 15 0 0 0 243 281A15 15 0 0 0 259 297Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="284" y="281" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">EXCEPT</text> +<polygon points="243,281 232,286 232,277" style="fill:rgb(0,0,0)"/> +<path d="M205,168 L 213,168 Q 220,168 220,183 L 220,266 Q 220,281 229,281 L 238,281" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="243,244 232,248 232,239" style="fill:rgb(0,0,0)"/> +<path d="M220,228 L 220,236 Q 220,244 229,244 L 238,244" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="243,206 232,210 232,201" style="fill:rgb(0,0,0)"/> +<path d="M220,191 L 220,198 Q 220,206 229,206 L 238,206" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="409,244 397,248 397,239" style="fill:rgb(0,0,0)"/> +<path d="M359,244L403,244" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M409,244 L 416,244 Q 424,244 424,229 L 424,206 L 424,191" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="409,281 397,286 397,277" style="fill:rgb(0,0,0)"/> +<path d="M325,281L403,281" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M409,281 L 416,281 Q 424,281 424,266 L 424,243 L 424,228" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M317,168L435,168" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="378,138 389,133 389,142" style="fill:rgb(0,0,0)"/> +<path d="M550,168 L 558,168 Q 565,168 565,153 L 565,153 Q 565,138 550,138 L 399,138 L 384,138" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M378,138 L 205,138 Q 190,138 190,153 L 190,153 Q 190,168 198,168 L 205,168" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="319,315 331,311 331,320" style="fill:rgb(0,0,0)"/> +<path d="M550,168 L 571,168 Q 586,168 586,183 L 586,300 Q 586,315 571,315 L 340,315 L 325,315" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="68,349 56,354 56,345" style="fill:rgb(0,0,0)"/> +<path d="M319,315 L 62,315 Q 47,315 47,330 L 47,334 Q 47,349 55,349 L 62,349" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="245,349 234,354 234,345" style="fill:rgb(0,0,0)"/> +<path d="M200,349L239,349" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M245,365L375,365L375,334L245,334Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="310" y="349" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ordering-term</text> +<path d="M310,402A15 15 0 0 0 325 387A15 15 0 0 0 310 372A15 15 0 0 0 295 387A15 15 0 0 0 310 402Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="310" y="387" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text> +<polygon points="325,387 337,383 337,392" style="fill:rgb(0,0,0)"/> +<path d="M375,349 L 382,349 Q 390,349 390,364 L 390,372 Q 390,387 375,387 L 346,387 L 331,387" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M295,387 L 237,387 Q 222,387 222,372 L 222,364 Q 222,349 228,349 L 234,349" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="411,380 407,368 415,368" style="fill:rgb(0,0,0)"/> +<path d="M375,349 L 396,349 Q 411,349 411,362 L 411,374" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="221,421 233,417 233,426" style="fill:rgb(0,0,0)"/> +<path d="M411,380 L 411,406 Q 411,421 396,421 L 242,421 L 227,421" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="68,455 56,460 56,451" style="fill:rgb(0,0,0)"/> +<path d="M221,421 L 62,421 Q 47,421 47,436 L 47,440 Q 47,455 55,455 L 62,455" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="47,387 43,376 51,376" style="fill:rgb(0,0,0)"/> +<path d="M47,334L47,382" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M47,387L47,440" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M278,501L329,501A15 15 0 0 0 344 486A15 15 0 0 0 329 470L278,470A15 15 0 0 0 263 486A15 15 0 0 0 278 501Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="304" y="486" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">OFFSET</text> +<polygon points="367,486 356,490 356,481" style="fill:rgb(0,0,0)"/> +<path d="M344,486L362,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M367,501L417,501L417,470L367,470Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="392" y="486" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text> +<polygon points="440,486 428,490 428,481" style="fill:rgb(0,0,0)"/> +<path d="M417,486L434,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M278,538A15 15 0 0 0 293 523A15 15 0 0 0 278 508A15 15 0 0 0 263 523A15 15 0 0 0 278 538Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="278" y="523" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text> +<polygon points="316,523 305,528 305,519" style="fill:rgb(0,0,0)"/> +<path d="M293,523L310,523" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M316,538L365,538L365,508L316,508Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="341" y="523" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text> +<polygon points="227,455 215,460 215,451" style="fill:rgb(0,0,0)"/> +<path d="M204,455L221,455" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="263,523 251,528 251,519" style="fill:rgb(0,0,0)"/> +<path d="M227,455 L 234,455 Q 242,455 242,470 L 242,508 Q 242,523 249,523 L 257,523" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="263,486 251,490 251,481" style="fill:rgb(0,0,0)"/> +<path d="M227,455 L 234,455 Q 242,455 242,470 L 242,471 Q 242,486 249,486 L 257,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="440,455 428,460 428,451" style="fill:rgb(0,0,0)"/> +<path d="M227,455L434,455" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="642,554 631,558 631,549" style="fill:rgb(0,0,0)"/> +<path d="M440,455 L 461,455 Q 476,455 476,470 L 476,539 Q 476,554 491,554 L 622,554 L 637,554" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<circle cx="646" cy="554" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M440,486 L 461,486 Q 476,486 476,493 L 476,501" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="440,523 428,528 428,519" style="fill:rgb(0,0,0)"/> +<path d="M365,523L434,523" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M440,523 L 461,523 Q 476,523 476,531 L 476,538" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="440,554 428,558 428,549" style="fill:rgb(0,0,0)"/> +<path d="M47,440 L 47,539 Q 47,554 62,554 L 419,554 L 434,554" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M440,554L512,554" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +</svg> +</div><br> +<br></br> +References: <a href='./common-table-expression.html'>common-table-expression</a> <a href='./expr.html'>expr</a> <a href='./ordering-term.html'>ordering-term</a> <a href='./select-core.html'>select-core</a><br></br> +See also: <a href='../lang_select.html'>lang_select.html</a> +</div> + + + |