CINXE.COM

<!DOCTYPE html> <html class="client-nojs vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-sticky-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-1 vector-feature-night-mode-enabled skin-theme-clientpref-day vector-toc-available" lang="nl" dir="ltr"> <head> <meta charset="UTF-8"> <title>Select (SQL) - Wikipedia</title> <script>(function(){var className="client-js vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-sticky-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-1 vector-feature-night-mode-enabled skin-theme-clientpref-day vector-toc-available";var cookie=document.cookie.match(/(?:^|; )nlwikimwclientpreferences=([^;]+)/);if(cookie){cookie[1].split('%2C').forEach(function(pref){className=className.replace(new RegExp('(^| )'+pref.replace(/-clientpref-\w+$|[^\w-]+/g,'')+'-clientpref-\\w+( |$)'),'$1'+pref+'$2');});}document.documentElement.className=className;}());RLCONF={"wgBreakFrames":false,"wgSeparatorTransformTable":[",\t.",".\t,"],"wgDigitTransformTable":["",""], "wgDefaultDateFormat":"dmy","wgMonthNames":["","januari","februari","maart","april","mei","juni","juli","augustus","september","oktober","november","december"],"wgRequestId":"299d8a3a-ce59-4c17-a737-292ab423da14","wgCanonicalNamespace":"","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":0,"wgPageName":"Select_(SQL)","wgTitle":"Select (SQL)","wgCurRevisionId":68057805,"wgRevisionId":68057805,"wgArticleId":251783,"wgIsArticle":true,"wgIsRedirect":false,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":["SQL","Relationele database"],"wgPageViewLanguage":"nl","wgPageContentLanguage":"nl","wgPageContentModel":"wikitext","wgRelevantPageName":"Select_(SQL)","wgRelevantArticleId":251783,"wgIsProbablyEditable":true,"wgRelevantPageIsProbablyEditable":true,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgNoticeProject":"wikipedia","wgCiteReferencePreviewsActive":true,"wgMediaViewerOnClick":true,"wgMediaViewerEnabledByDefault":true,"wgPopupsFlags":0,"wgVisualEditor":{ "pageLanguageCode":"nl","pageLanguageDir":"ltr","pageVariantFallbacks":"nl"},"wgMFDisplayWikibaseDescriptions":{"search":true,"watchlist":true,"tagline":true,"nearby":true},"wgWMESchemaEditAttemptStepOversample":false,"wgWMEPageLength":5000,"wgRelatedArticlesCompat":[],"wgEditSubmitButtonLabelPublish":true,"wgULSPosition":"interlanguage","wgULSisCompactLinksEnabled":false,"wgVector2022LanguageInHeader":true,"wgULSisLanguageSelectorEmpty":false,"wgWikibaseItemId":"Q1164001","wgCheckUserClientHintsHeadersJsApi":["brands","architecture","bitness","fullVersionList","mobile","model","platform","platformVersion"],"GEHomepageSuggestedEditsEnableTopics":true,"wgGETopicsMatchModeEnabled":false,"wgGEStructuredTaskRejectionReasonTextInputEnabled":false,"wgGELevelingUpEnabledForUser":false};RLSTATE={"ext.globalCssJs.user.styles":"ready","site.styles":"ready","user.styles":"ready","ext.globalCssJs.user":"ready","user":"ready","user.options":"loading","ext.pygments":"ready","ext.cite.styles":"ready" ,"skins.vector.search.codex.styles":"ready","skins.vector.styles":"ready","skins.vector.icons":"ready","ext.wikimediamessages.styles":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","ext.uls.interlanguage":"ready","wikibase.client.init":"ready","ext.wikimediaBadges":"ready"};RLPAGEMODULES=["ext.pygments.view","ext.cite.ux-enhancements","site","mediawiki.page.ready","mediawiki.toc","skins.vector.js","ext.centralNotice.geoIP","ext.centralNotice.startUp","ext.gadget.Direct-link-to-Commons","ext.gadget.ProtectionTemplates","ext.gadget.InterProjectLinks","ext.gadget.hoofdbetekenis-titelwijziging","ext.gadget.switcher","ext.gadget.OpenStreetMapFrame","ext.gadget.subpages","ext.urlShortener.toolbar","ext.centralauth.centralautologin","mmv.bootstrap","ext.popups","ext.visualEditor.desktopArticleTarget.init","ext.visualEditor.targetLoader","ext.echo.centralauth","ext.eventLogging","ext.wikimediaEvents","ext.navigationTiming","ext.uls.interface","ext.cx.eventlogging.campaigns", "ext.cx.uls.quick.actions","wikibase.client.vector-2022","ext.checkUser.clientHints","ext.growthExperiments.SuggestedEditSession"];</script> <script>(RLQ=window.RLQ||[]).push(function(){mw.loader.impl(function(){return["user.options@12s5i",function($,jQuery,require,module){mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"}); }];});});</script> <link rel="stylesheet" href="/w/load.php?lang=nl&modules=ext.cite.styles%7Cext.pygments%2CwikimediaBadges%7Cext.uls.interlanguage%7Cext.visualEditor.desktopArticleTarget.noscript%7Cext.wikimediamessages.styles%7Cskins.vector.icons%2Cstyles%7Cskins.vector.search.codex.styles%7Cwikibase.client.init&only=styles&skin=vector-2022"> <script async="" src="/w/load.php?lang=nl&modules=startup&only=scripts&raw=1&skin=vector-2022"></script> <meta name="ResourceLoaderDynamicStyles" content=""> <link rel="stylesheet" href="/w/load.php?lang=nl&modules=site.styles&only=styles&skin=vector-2022"> <meta name="generator" content="MediaWiki 1.44.0-wmf.6"> <meta name="referrer" content="origin"> <meta name="referrer" content="origin-when-cross-origin"> <meta name="robots" content="max-image-preview:standard"> <meta name="format-detection" content="telephone=no"> <meta name="viewport" content="width=1120"> <meta property="og:title" content="Select (SQL) - Wikipedia"> <meta property="og:type" content="website"> <link rel="preconnect" href="//upload.wikimedia.org"> <link rel="alternate" media="only screen and (max-width: 640px)" href="//nl.m.wikipedia.org/wiki/Select_(SQL)"> <link rel="alternate" type="application/x-wiki" title="Bewerken" href="/w/index.php?title=Select_(SQL)&action=edit"> <link rel="apple-touch-icon" href="/static/apple-touch/wikipedia.png"> <link rel="icon" href="/static/favicon/wikipedia.ico"> <link rel="search" type="application/opensearchdescription+xml" href="/w/rest.php/v1/search" title="Wikipedia (nl)"> <link rel="EditURI" type="application/rsd+xml" href="//nl.wikipedia.org/w/api.php?action=rsd"> <link rel="canonical" href="https://nl.wikipedia.org/wiki/Select_(SQL)"> <link rel="license" href="https://creativecommons.org/licenses/by-sa/4.0/deed.nl"> <link rel="alternate" type="application/atom+xml" title="Wikipedia Atom-feed" href="/w/index.php?title=Speciaal:RecenteWijzigingen&feed=atom"> <link rel="dns-prefetch" href="//meta.wikimedia.org" /> <link rel="dns-prefetch" href="login.wikimedia.org"> </head> <body class="skin--responsive skin-vector skin-vector-search-vue mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-0 ns-subject mw-editable page-Select_SQL rootpage-Select_SQL skin-vector-2022 action-view"><a class="mw-jump-link" href="#bodyContent">Naar inhoud springen</a> <div class="vector-header-container"> <header class="vector-header mw-header"> <div class="vector-header-start"> <nav class="vector-main-menu-landmark" aria-label="Site"> <div id="vector-main-menu-dropdown" class="vector-dropdown vector-main-menu-dropdown vector-button-flush-left vector-button-flush-right" > <input type="checkbox" id="vector-main-menu-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-main-menu-dropdown" class="vector-dropdown-checkbox " aria-label="Hoofdmenu" > <label id="vector-main-menu-dropdown-label" for="vector-main-menu-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-menu mw-ui-icon-wikimedia-menu"></span> <span class="vector-dropdown-label-text">Hoofdmenu</span> </label> <div class="vector-dropdown-content"> <div id="vector-main-menu-unpinned-container" class="vector-unpinned-container"> <div id="vector-main-menu" class="vector-main-menu vector-pinnable-element"> <div class="vector-pinnable-header vector-main-menu-pinnable-header vector-pinnable-header-unpinned" data-feature-name="main-menu-pinned" data-pinnable-element-id="vector-main-menu" data-pinned-container-id="vector-main-menu-pinned-container" data-unpinned-container-id="vector-main-menu-unpinned-container" > <div class="vector-pinnable-header-label">Hoofdmenu</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-main-menu.pin">naar zijbalk verplaatsen</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-main-menu.unpin">verbergen</button> </div> <div id="p-navigation" class="vector-menu mw-portlet mw-portlet-navigation" > <div class="vector-menu-heading"> Navigatie </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-mainpage" class="mw-list-item"><a href="/wiki/Hoofdpagina" title="Naar de hoofdpagina gaan [z]" accesskey="z"><span>Hoofdpagina</span></a></li><li id="n-zoekartikel" class="mw-list-item"><a href="/wiki/Portaal:Navigatie"><span>Vind een artikel</span></a></li><li id="n-today" class="mw-list-item"><a href="/wiki/11_december"><span>Vandaag</span></a></li><li id="n-Etalage" class="mw-list-item"><a href="/wiki/Wikipedia:Etalage"><span>Etalage</span></a></li><li id="n-categories" class="mw-list-item"><a href="/wiki/Categorie:Alles"><span>Categorieën</span></a></li><li id="n-recentchanges" class="mw-list-item"><a href="/wiki/Speciaal:RecenteWijzigingen" title="Een lijst met recente wijzigingen in deze wiki. [r]" accesskey="r"><span>Recente wijzigingen</span></a></li><li id="n-newpages" class="mw-list-item"><a href="/wiki/Speciaal:NieuwePaginas"><span>Nieuwe artikelen</span></a></li><li id="n-randompage" class="mw-list-item"><a href="/wiki/Speciaal:Willekeurig" title="Een willekeurige pagina bekijken [x]" accesskey="x"><span>Willekeurige pagina</span></a></li> </ul> </div> </div> <div id="p-navigation2" class="vector-menu mw-portlet mw-portlet-navigation2" > <div class="vector-menu-heading"> Informatie </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-portal" class="mw-list-item"><a href="/wiki/Portaal:Gebruikersportaal" title="Informatie over het project: wat u kunt doen, waar u dingen kunt vinden"><span>Gebruikersportaal</span></a></li><li id="n-Snelcursus" class="mw-list-item"><a href="/wiki/Wikipedia:Snelcursus"><span>Snelcursus</span></a></li><li id="n-help" class="mw-list-item"><a href="/wiki/Portaal:Hulp_en_beheer" title="Hulpinformatie over deze wiki"><span>Hulp en contact</span></a></li> </ul> </div> </div> </div> </div> </div> </div> </nav> <a href="/wiki/Hoofdpagina" class="mw-logo"> <img class="mw-logo-icon" src="/static/images/icons/wikipedia.png" alt="" aria-hidden="true" height="50" width="50"> <span class="mw-logo-container skin-invert"> <img class="mw-logo-wordmark" alt="Wikipedia" src="/static/images/mobile/copyright/wikipedia-wordmark-en.svg" style="width: 7.5em; height: 1.125em;"> <img class="mw-logo-tagline" alt="de vrije encyclopedie" src="/static/images/mobile/copyright/wikipedia-tagline-nl.svg" width="120" height="13" style="width: 7.5em; height: 0.8125em;"> </span> </a> </div> <div class="vector-header-end"> <div id="p-search" role="search" class="vector-search-box-vue vector-search-box-collapses vector-search-box-show-thumbnail vector-search-box-auto-expand-width vector-search-box"> <a href="/wiki/Speciaal:Zoeken" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only search-toggle" title="Doorzoek Wikipedia [f]" accesskey="f"><span class="vector-icon mw-ui-icon-search mw-ui-icon-wikimedia-search"></span> <span>Zoeken</span> </a> <div class="vector-typeahead-search-container"> <div class="cdx-typeahead-search cdx-typeahead-search--show-thumbnail cdx-typeahead-search--auto-expand-width"> <form action="/w/index.php" id="searchform" class="cdx-search-input cdx-search-input--has-end-button"> <div id="simpleSearch" class="cdx-search-input__input-wrapper" data-search-loc="header-moved"> <div class="cdx-text-input cdx-text-input--has-start-icon"> <input class="cdx-text-input__input" type="search" name="search" placeholder="Doorzoek Wikipedia" aria-label="Doorzoek Wikipedia" autocapitalize="sentences" title="Doorzoek Wikipedia [f]" accesskey="f" id="searchInput" > <span class="cdx-text-input__icon cdx-text-input__start-icon"></span> </div> <input type="hidden" name="title" value="Speciaal:Zoeken"> </div> <button class="cdx-button cdx-search-input__end-button">Zoeken</button> </form> </div> </div> </div> <nav class="vector-user-links vector-user-links-wide" aria-label="Persoonlijke hulpmiddelen"> <div class="vector-user-links-main"> <div id="p-vector-user-menu-preferences" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <div id="p-vector-user-menu-userpage" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <nav class="vector-appearance-landmark" aria-label="Uiterlijk"> <div id="vector-appearance-dropdown" class="vector-dropdown " title="De lettergrootte, breedte en kleur van de pagina wijzigen" > <input type="checkbox" id="vector-appearance-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-appearance-dropdown" class="vector-dropdown-checkbox " aria-label="Uiterlijk" > <label id="vector-appearance-dropdown-label" for="vector-appearance-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-appearance mw-ui-icon-wikimedia-appearance"></span> <span class="vector-dropdown-label-text">Uiterlijk</span> </label> <div class="vector-dropdown-content"> <div id="vector-appearance-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <div id="p-vector-user-menu-notifications" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <div id="p-vector-user-menu-overflow" class="vector-menu mw-portlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-sitesupport-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="https://donate.wikimedia.org/?wmf_source=donate&wmf_medium=sidebar&wmf_campaign=nl.wikipedia.org&uselang=nl" class=""><span>Doneren</span></a> </li> <li id="pt-createaccount-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="/w/index.php?title=Speciaal:GebruikerAanmaken&returnto=Select+%28SQL%29" title="Registreer u vooral en meld u aan. Dit is echter niet verplicht." class=""><span>Account aanmaken</span></a> </li> <li id="pt-login-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="/w/index.php?title=Speciaal:Aanmelden&returnto=Select+%28SQL%29" title="U wordt van harte uitgenodigd om aan te melden, maar dit is niet verplicht [o]" accesskey="o" class=""><span>Aanmelden</span></a> </li> </ul> </div> </div> </div> <div id="vector-user-links-dropdown" class="vector-dropdown vector-user-menu vector-button-flush-right vector-user-menu-logged-out" title="Meer opties" > <input type="checkbox" id="vector-user-links-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-user-links-dropdown" class="vector-dropdown-checkbox " aria-label="Persoonlijke hulpmiddelen" > <label id="vector-user-links-dropdown-label" for="vector-user-links-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-ellipsis mw-ui-icon-wikimedia-ellipsis"></span> <span class="vector-dropdown-label-text">Persoonlijke hulpmiddelen</span> </label> <div class="vector-dropdown-content"> <div id="p-personal" class="vector-menu mw-portlet mw-portlet-personal user-links-collapsible-item" title="Gebruikersmenu" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-sitesupport" class="user-links-collapsible-item mw-list-item"><a href="https://donate.wikimedia.org/?wmf_source=donate&wmf_medium=sidebar&wmf_campaign=nl.wikipedia.org&uselang=nl"><span>Doneren</span></a></li><li id="pt-createaccount" class="user-links-collapsible-item mw-list-item"><a href="/w/index.php?title=Speciaal:GebruikerAanmaken&returnto=Select+%28SQL%29" title="Registreer u vooral en meld u aan. Dit is echter niet verplicht."><span class="vector-icon mw-ui-icon-userAdd mw-ui-icon-wikimedia-userAdd"></span> <span>Account aanmaken</span></a></li><li id="pt-login" class="user-links-collapsible-item mw-list-item"><a href="/w/index.php?title=Speciaal:Aanmelden&returnto=Select+%28SQL%29" title="U wordt van harte uitgenodigd om aan te melden, maar dit is niet verplicht [o]" accesskey="o"><span class="vector-icon mw-ui-icon-logIn mw-ui-icon-wikimedia-logIn"></span> <span>Aanmelden</span></a></li> </ul> </div> </div> <div id="p-user-menu-anon-editor" class="vector-menu mw-portlet mw-portlet-user-menu-anon-editor" > <div class="vector-menu-heading"> Pagina's voor uitgelogde redacteuren <a href="/wiki/Help:Inleiding" aria-label="Meer leren over bewerken"><span>meer lezen</span></a> </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-anoncontribs" class="mw-list-item"><a href="/wiki/Speciaal:MijnBijdragen" title="Bijdragen IP-adres [y]" accesskey="y"><span>Bijdragen</span></a></li><li id="pt-anontalk" class="mw-list-item"><a href="/wiki/Speciaal:MijnOverleg" title="Overlegpagina van de anonieme gebruiker van dit IP-adres [n]" accesskey="n"><span>Overleg</span></a></li> </ul> </div> </div> </div> </div> </nav> </div> </header> </div> <div class="mw-page-container"> <div class="mw-page-container-inner"> <div class="vector-sitenotice-container"> <div id="siteNotice"></div> </div> <div class="vector-column-start"> <div class="vector-main-menu-container"> <div id="mw-navigation"> <nav id="mw-panel" class="vector-main-menu-landmark" aria-label="Site"> <div id="vector-main-menu-pinned-container" class="vector-pinned-container"> </div> </nav> </div> </div> <div class="vector-sticky-pinned-container"> <nav id="mw-panel-toc" aria-label="Inhoud" data-event-name="ui.sidebar-toc" class="mw-table-of-contents-container vector-toc-landmark"> <div id="vector-toc-pinned-container" class="vector-pinned-container"> <div id="vector-toc" class="vector-toc vector-pinnable-element"> <div class="vector-pinnable-header vector-toc-pinnable-header vector-pinnable-header-pinned" data-feature-name="toc-pinned" data-pinnable-element-id="vector-toc" > <h2 class="vector-pinnable-header-label">Inhoud</h2> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-toc.pin">naar zijbalk verplaatsen</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-toc.unpin">verbergen</button> </div> <ul class="vector-toc-contents" id="mw-panel-toc-list"> <li id="toc-mw-content-text" class="vector-toc-list-item vector-toc-level-1"> <a href="#" class="vector-toc-link"> <div class="vector-toc-text">Top</div> </a> </li> <li id="toc-Sleutelwoorden" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Sleutelwoorden"> <div class="vector-toc-text"> <span class="vector-toc-numb">1</span> <span>Sleutelwoorden</span> </div> </a> <ul id="toc-Sleutelwoorden-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-SELECT-syntaxis" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#SELECT-syntaxis"> <div class="vector-toc-text"> <span class="vector-toc-numb">2</span> <span>SELECT-syntaxis</span> </div> </a> <button aria-controls="toc-SELECT-syntaxis-sublist" class="cdx-button cdx-button--weight-quiet cdx-button--icon-only vector-toc-toggle"> <span class="vector-icon mw-ui-icon-wikimedia-expand"></span> <span>SELECT-syntaxis-subkopje inklappen</span> </button> <ul id="toc-SELECT-syntaxis-sublist" class="vector-toc-list"> <li id="toc-CTE" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#CTE"> <div class="vector-toc-text"> <span class="vector-toc-numb">2.1</span> <span>CTE</span> </div> </a> <ul id="toc-CTE-sublist" class="vector-toc-list"> </ul> </li> </ul> </li> <li id="toc-Voorbeelden" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Voorbeelden"> <div class="vector-toc-text"> <span class="vector-toc-numb">3</span> <span>Voorbeelden</span> </div> </a> <ul id="toc-Voorbeelden-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Join" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Join"> <div class="vector-toc-text"> <span class="vector-toc-numb">4</span> <span>Join</span> </div> </a> <ul id="toc-Join-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Zie_ook" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Zie_ook"> <div class="vector-toc-text"> <span class="vector-toc-numb">5</span> <span>Zie ook</span> </div> </a> <ul id="toc-Zie_ook-sublist" class="vector-toc-list"> </ul> </li> </ul> </div> </div> </nav> </div> </div> <div class="mw-content-container"> <main id="content" class="mw-body"> <header class="mw-body-header vector-page-titlebar"> <nav aria-label="Inhoud" class="vector-toc-landmark"> <div id="vector-page-titlebar-toc" class="vector-dropdown vector-page-titlebar-toc vector-button-flush-left" > <input type="checkbox" id="vector-page-titlebar-toc-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-page-titlebar-toc" class="vector-dropdown-checkbox " aria-label="Inhoudsopgave omschakelen" > <label id="vector-page-titlebar-toc-label" for="vector-page-titlebar-toc-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-listBullet mw-ui-icon-wikimedia-listBullet"></span> <span class="vector-dropdown-label-text">Inhoudsopgave omschakelen</span> </label> <div class="vector-dropdown-content"> <div id="vector-page-titlebar-toc-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <h1 id="firstHeading" class="firstHeading mw-first-heading"><span class="mw-page-title-main">Select (SQL)</span></h1> <div id="p-lang-btn" class="vector-dropdown mw-portlet mw-portlet-lang" > <input type="checkbox" id="p-lang-btn-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-lang-btn" class="vector-dropdown-checkbox mw-interlanguage-selector" aria-label="Ga naar een artikel in een andere taal. Beschikbaar in 19 talen" > <label id="p-lang-btn-label" for="p-lang-btn-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--action-progressive mw-portlet-lang-heading-19" aria-hidden="true" ><span class="vector-icon mw-ui-icon-language-progressive mw-ui-icon-wikimedia-language-progressive"></span> <span class="vector-dropdown-label-text">19 talen</span> </label> <div class="vector-dropdown-content"> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li class="interlanguage-link interwiki-ca mw-list-item"><a href="https://ca.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Catalaans" lang="ca" hreflang="ca" data-title="Select (SQL)" data-language-autonym="Català" data-language-local-name="Catalaans" class="interlanguage-link-target"><span>Català</span></a></li><li class="interlanguage-link interwiki-cs mw-list-item"><a href="https://cs.wikipedia.org/wiki/SELECT" title="SELECT – Tsjechisch" lang="cs" hreflang="cs" data-title="SELECT" data-language-autonym="Čeština" data-language-local-name="Tsjechisch" class="interlanguage-link-target"><span>Čeština</span></a></li><li class="interlanguage-link interwiki-de mw-list-item"><a href="https://de.wikipedia.org/wiki/Selektion_(Informatik)" title="Selektion (Informatik) – Duits" lang="de" hreflang="de" data-title="Selektion (Informatik)" data-language-autonym="Deutsch" data-language-local-name="Duits" class="interlanguage-link-target"><span>Deutsch</span></a></li><li class="interlanguage-link interwiki-en mw-list-item"><a href="https://en.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Engels" lang="en" hreflang="en" data-title="Select (SQL)" data-language-autonym="English" data-language-local-name="Engels" class="interlanguage-link-target"><span>English</span></a></li><li class="interlanguage-link interwiki-fr mw-list-item"><a href="https://fr.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Frans" lang="fr" hreflang="fr" data-title="Select (SQL)" data-language-autonym="Français" data-language-local-name="Frans" class="interlanguage-link-target"><span>Français</span></a></li><li class="interlanguage-link interwiki-hr mw-list-item"><a href="https://hr.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Kroatisch" lang="hr" hreflang="hr" data-title="Select (SQL)" data-language-autonym="Hrvatski" data-language-local-name="Kroatisch" class="interlanguage-link-target"><span>Hrvatski</span></a></li><li class="interlanguage-link interwiki-ja mw-list-item"><a href="https://ja.wikipedia.org/wiki/SELECT_(SQL)" title="SELECT (SQL) – Japans" lang="ja" hreflang="ja" data-title="SELECT (SQL)" data-language-autonym="日本語" data-language-local-name="Japans" class="interlanguage-link-target"><span>日本語</span></a></li><li class="interlanguage-link interwiki-ko mw-list-item"><a href="https://ko.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Koreaans" lang="ko" hreflang="ko" data-title="Select (SQL)" data-language-autonym="한국어" data-language-local-name="Koreaans" class="interlanguage-link-target"><span>한국어</span></a></li><li class="interlanguage-link interwiki-lv mw-list-item"><a href="https://lv.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Lets" lang="lv" hreflang="lv" data-title="Select (SQL)" data-language-autonym="Latviešu" data-language-local-name="Lets" class="interlanguage-link-target"><span>Latviešu</span></a></li><li class="interlanguage-link interwiki-no mw-list-item"><a href="https://no.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Noors - Bokmål" lang="nb" hreflang="nb" data-title="Select (SQL)" data-language-autonym="Norsk bokmål" data-language-local-name="Noors - Bokmål" class="interlanguage-link-target"><span>Norsk bokmål</span></a></li><li class="interlanguage-link interwiki-pt mw-list-item"><a href="https://pt.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Portugees" lang="pt" hreflang="pt" data-title="Select (SQL)" data-language-autonym="Português" data-language-local-name="Portugees" class="interlanguage-link-target"><span>Português</span></a></li><li class="interlanguage-link interwiki-ru mw-list-item"><a href="https://ru.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Russisch" lang="ru" hreflang="ru" data-title="Select (SQL)" data-language-autonym="Русский" data-language-local-name="Russisch" class="interlanguage-link-target"><span>Русский</span></a></li><li class="interlanguage-link interwiki-sk mw-list-item"><a href="https://sk.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Slowaaks" lang="sk" hreflang="sk" data-title="Select (SQL)" data-language-autonym="Slovenčina" data-language-local-name="Slowaaks" class="interlanguage-link-target"><span>Slovenčina</span></a></li><li class="interlanguage-link interwiki-sq mw-list-item"><a href="https://sq.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Albanees" lang="sq" hreflang="sq" data-title="Select (SQL)" data-language-autonym="Shqip" data-language-local-name="Albanees" class="interlanguage-link-target"><span>Shqip</span></a></li><li class="interlanguage-link interwiki-sr mw-list-item"><a href="https://sr.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Servisch" lang="sr" hreflang="sr" data-title="Select (SQL)" data-language-autonym="Српски / srpski" data-language-local-name="Servisch" class="interlanguage-link-target"><span>Српски / srpski</span></a></li><li class="interlanguage-link interwiki-tg mw-list-item"><a href="https://tg.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Tadzjieks" lang="tg" hreflang="tg" data-title="Select (SQL)" data-language-autonym="Тоҷикӣ" data-language-local-name="Tadzjieks" class="interlanguage-link-target"><span>Тоҷикӣ</span></a></li><li class="interlanguage-link interwiki-uk mw-list-item"><a href="https://uk.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Oekraïens" lang="uk" hreflang="uk" data-title="Select (SQL)" data-language-autonym="Українська" data-language-local-name="Oekraïens" class="interlanguage-link-target"><span>Українська</span></a></li><li class="interlanguage-link interwiki-vi mw-list-item"><a href="https://vi.wikipedia.org/wiki/Select_(SQL)" title="Select (SQL) – Vietnamees" lang="vi" hreflang="vi" data-title="Select (SQL)" data-language-autonym="Tiếng Việt" data-language-local-name="Vietnamees" class="interlanguage-link-target"><span>Tiếng Việt</span></a></li><li class="interlanguage-link interwiki-zh mw-list-item"><a href="https://zh.wikipedia.org/wiki/%E6%9F%A5%E8%AF%A2_(SQL)" title="查询 (SQL) – Chinees" lang="zh" hreflang="zh" data-title="查询 (SQL)" data-language-autonym="中文" data-language-local-name="Chinees" class="interlanguage-link-target"><span>中文</span></a></li> </ul> <div class="after-portlet after-portlet-lang"><span class="wb-langlinks-edit wb-langlinks-link"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q1164001#sitelinks-wikipedia" title="Taalkoppelingen bewerken" class="wbc-editpage">Koppelingen bewerken</a></span></div> </div> </div> </div> </header> <div class="vector-page-toolbar"> <div class="vector-page-toolbar-container"> <div id="left-navigation"> <nav aria-label="Naamruimten"> <div id="p-associated-pages" class="vector-menu vector-menu-tabs mw-portlet mw-portlet-associated-pages" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-nstab-main" class="selected vector-tab-noicon mw-list-item"><a href="/wiki/Select_(SQL)" title="Inhoudspagina bekijken [c]" accesskey="c"><span>Artikel</span></a></li><li id="ca-talk" class="vector-tab-noicon mw-list-item"><a href="/wiki/Overleg:Select_(SQL)" rel="discussion" title="Overleg over deze pagina [t]" accesskey="t"><span>Overleg</span></a></li> </ul> </div> </div> <div id="vector-variants-dropdown" class="vector-dropdown emptyPortlet" > <input type="checkbox" id="vector-variants-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-variants-dropdown" class="vector-dropdown-checkbox " aria-label="Taalvariant wijzigen" > <label id="vector-variants-dropdown-label" for="vector-variants-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet" aria-hidden="true" ><span class="vector-dropdown-label-text">Nederlands</span> </label> <div class="vector-dropdown-content"> <div id="p-variants" class="vector-menu mw-portlet mw-portlet-variants emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> </div> </div> </nav> </div> <div id="right-navigation" class="vector-collapsible"> <nav aria-label="Weergaven"> <div id="p-views" class="vector-menu vector-menu-tabs mw-portlet mw-portlet-views" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-view" class="selected vector-tab-noicon mw-list-item"><a href="/wiki/Select_(SQL)"><span>Lezen</span></a></li><li id="ca-ve-edit" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Select_(SQL)&veaction=edit" title="Deze pagina bewerken [v]" accesskey="v"><span>Bewerken</span></a></li><li id="ca-edit" class="collapsible vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Select_(SQL)&action=edit" title="Broncode van deze pagina bewerken [e]" accesskey="e"><span>Brontekst bewerken</span></a></li><li id="ca-history" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Select_(SQL)&action=history" title="Eerdere versies van deze pagina [h]" accesskey="h"><span>Geschiedenis weergeven</span></a></li> </ul> </div> </div> </nav> <nav class="vector-page-tools-landmark" aria-label="Paginahulpmiddelen"> <div id="vector-page-tools-dropdown" class="vector-dropdown vector-page-tools-dropdown" > <input type="checkbox" id="vector-page-tools-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-page-tools-dropdown" class="vector-dropdown-checkbox " aria-label="Hulpmiddelen" > <label id="vector-page-tools-dropdown-label" for="vector-page-tools-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet" aria-hidden="true" ><span class="vector-dropdown-label-text">Hulpmiddelen</span> </label> <div class="vector-dropdown-content"> <div id="vector-page-tools-unpinned-container" class="vector-unpinned-container"> <div id="vector-page-tools" class="vector-page-tools vector-pinnable-element"> <div class="vector-pinnable-header vector-page-tools-pinnable-header vector-pinnable-header-unpinned" data-feature-name="page-tools-pinned" data-pinnable-element-id="vector-page-tools" data-pinned-container-id="vector-page-tools-pinned-container" data-unpinned-container-id="vector-page-tools-unpinned-container" > <div class="vector-pinnable-header-label">Hulpmiddelen</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-page-tools.pin">naar zijbalk verplaatsen</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-page-tools.unpin">verbergen</button> </div> <div id="p-cactions" class="vector-menu mw-portlet mw-portlet-cactions emptyPortlet vector-has-collapsible-items" title="Meer opties" > <div class="vector-menu-heading"> Handelingen </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-more-view" class="selected vector-more-collapsible-item mw-list-item"><a href="/wiki/Select_(SQL)"><span>Lezen</span></a></li><li id="ca-more-ve-edit" class="vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=Select_(SQL)&veaction=edit" title="Deze pagina bewerken [v]" accesskey="v"><span>Bewerken</span></a></li><li id="ca-more-edit" class="collapsible vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=Select_(SQL)&action=edit" title="Broncode van deze pagina bewerken [e]" accesskey="e"><span>Brontekst bewerken</span></a></li><li id="ca-more-history" class="vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=Select_(SQL)&action=history"><span>Geschiedenis weergeven</span></a></li> </ul> </div> </div> <div id="p-tb" class="vector-menu mw-portlet mw-portlet-tb" > <div class="vector-menu-heading"> Algemeen </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-whatlinkshere" class="mw-list-item"><a href="/wiki/Speciaal:VerwijzingenNaarHier/Select_(SQL)" title="Lijst met alle pagina's die naar deze pagina verwijzen [j]" accesskey="j"><span>Links naar deze pagina</span></a></li><li id="t-recentchangeslinked" class="mw-list-item"><a href="/wiki/Speciaal:RecenteWijzigingenGelinkt/Select_(SQL)" rel="nofollow" title="Recente wijzigingen in pagina's waar deze pagina naar verwijst [k]" accesskey="k"><span>Gerelateerde wijzigingen</span></a></li><li id="t-upload" class="mw-list-item"><a href="//commons.wikimedia.org/wiki/Special:UploadWizard?uselang=nl" title="Bestanden uploaden [u]" accesskey="u"><span>Bestand uploaden</span></a></li><li id="t-specialpages" class="mw-list-item"><a href="/wiki/Speciaal:SpecialePaginas" title="Lijst met alle speciale pagina's [q]" accesskey="q"><span>Speciale pagina's</span></a></li><li id="t-permalink" class="mw-list-item"><a href="/w/index.php?title=Select_(SQL)&oldid=68057805" title="Permanente koppeling naar deze versie van deze pagina"><span>Permanente koppeling</span></a></li><li id="t-info" class="mw-list-item"><a href="/w/index.php?title=Select_(SQL)&action=info" title="Meer informatie over deze pagina"><span>Paginagegevens</span></a></li><li id="t-cite" class="mw-list-item"><a href="/w/index.php?title=Speciaal:Citeren&page=Select_%28SQL%29&id=68057805&wpFormIdentifier=titleform" title="Informatie over hoe u deze pagina kunt citeren"><span>Deze pagina citeren</span></a></li><li id="t-urlshortener" class="mw-list-item"><a href="/w/index.php?title=Speciaal:UrlQ%C4%B1sald%C4%B1c%C4%B1s%C4%B1&url=https%3A%2F%2Fnl.wikipedia.org%2Fwiki%2FSelect_%28SQL%29"><span>Verkorte URL verkrijgen</span></a></li><li id="t-urlshortener-qrcode" class="mw-list-item"><a href="/w/index.php?title=Speciaal:QrKodu&url=https%3A%2F%2Fnl.wikipedia.org%2Fwiki%2FSelect_%28SQL%29"><span>QR-code downloaden</span></a></li> </ul> </div> </div> <div id="p-coll-print_export" class="vector-menu mw-portlet mw-portlet-coll-print_export" > <div class="vector-menu-heading"> Afdrukken/exporteren </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="coll-create_a_book" class="mw-list-item"><a href="/w/index.php?title=Speciaal:Boek&bookcmd=book_creator&referer=Select+%28SQL%29"><span>Boek aanmaken</span></a></li><li id="coll-download-as-rl" class="mw-list-item"><a href="/w/index.php?title=Speciaal:DownloadAsPdf&page=Select_%28SQL%29&action=show-download-screen"><span>Downloaden als PDF</span></a></li><li id="t-print" class="mw-list-item"><a href="/w/index.php?title=Select_(SQL)&printable=yes" title="Printvriendelijke versie van deze pagina [p]" accesskey="p"><span>Afdrukversie</span></a></li> </ul> </div> </div> <div id="p-wikibase-otherprojects" class="vector-menu mw-portlet mw-portlet-wikibase-otherprojects" > <div class="vector-menu-heading"> In andere projecten </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-wikibase" class="wb-otherproject-link wb-otherproject-wikibase-dataitem mw-list-item"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q1164001" title="Koppeling naar item in verbonden gegevensrepository [g]" accesskey="g"><span>Wikidata-item</span></a></li> </ul> </div> </div> </div> </div> </div> </div> </nav> </div> </div> </div> <div class="vector-column-end"> <div class="vector-sticky-pinned-container"> <nav class="vector-page-tools-landmark" aria-label="Paginahulpmiddelen"> <div id="vector-page-tools-pinned-container" class="vector-pinned-container"> </div> </nav> <nav class="vector-appearance-landmark" aria-label="Uiterlijk"> <div id="vector-appearance-pinned-container" class="vector-pinned-container"> <div id="vector-appearance" class="vector-appearance vector-pinnable-element"> <div class="vector-pinnable-header vector-appearance-pinnable-header vector-pinnable-header-pinned" data-feature-name="appearance-pinned" data-pinnable-element-id="vector-appearance" data-pinned-container-id="vector-appearance-pinned-container" data-unpinned-container-id="vector-appearance-unpinned-container" > <div class="vector-pinnable-header-label">Uiterlijk</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-appearance.pin">naar zijbalk verplaatsen</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-appearance.unpin">verbergen</button> </div> </div> </div> </nav> </div> </div> <div id="bodyContent" class="vector-body" aria-labelledby="firstHeading" data-mw-ve-target-container> <div class="vector-body-before-content"> <div class="mw-indicators"> </div> <div id="siteSub" class="noprint">Uit Wikipedia, de vrije encyclopedie</div> </div> <div id="contentSub"><div id="mw-content-subtitle"></div></div> <div id="mw-content-text" class="mw-body-content"><div class="mw-content-ltr mw-parser-output" lang="nl" dir="ltr"><p>Een <b><kbd>SELECT</kbd></b>-opdracht in <a href="/wiki/SQL" title="SQL">SQL</a> geeft een verzameling rijen of <a href="/wiki/Rij_(database)" title="Rij (database)">records</a> terug uit een of meer tabellen van een <a href="/wiki/Database" title="Database">database</a>. Het resultaat van een <kbd>SELECT</kbd>-opdracht is dus een nieuwe (zij het virtuele, dat wil zeggen niet fysiek opgeslagen) tabel. </p><p>De opdracht wordt gebruikt om een <a href="/wiki/Query" title="Query">query</a> uit te voeren die nul of meer rijen ophaalt door data uit één of meer <a href="/wiki/Tabel_(database)" title="Tabel (database)">tabellen</a> van een database te raadplegen en mogelijk te converteren of zelfs samen te vatten. In de meeste toepassingen is <kbd>SELECT</kbd> het meest gebruikte <i><a href="/wiki/Data_manipulation_language" title="Data manipulation language">data manipulation language</a></i>-commando (DML) van SQL. </p> <meta property="mw:PageProp/toc" /> <div class="mw-heading mw-heading2"><h2 id="Sleutelwoorden">Sleutelwoorden</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Select_(SQL)&veaction=edit&section=1" title="Bewerk dit kopje: Sleutelwoorden" class="mw-editsection-visualeditor"><span>bewerken</span></a><span class="mw-editsection-divider"> | </span><a href="/w/index.php?title=Select_(SQL)&action=edit&section=1" title="De broncode bewerken van de sectie: Sleutelwoorden"><span>brontekst bewerken</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>Bij <kbd>SELECT</kbd> kunnen meestal de volgende sleutelwoorden worden gebruikt: </p> <ul><li><code>FROM</code> – het enige syntactisch verplichte sleutelwoord; om aan te geven welke tabel of tabellen ondervraagd wordt/worden.</li> <li><code>WHERE</code> – gebruikt om op te geven welke rijen moeten worden opgehaald door middel van één of meerdere criteria.</li> <li><code>GROUP BY</code> – gebruikt om rijen (met dezelfde waarde in de opgegeven expressie) samen te brengen in een kleinere groep rijen.</li> <li><code>HAVING</code> – gebruikt samen met <kbd>GROUP BY</kbd> om te bepalen welke groepen opgehaald moeten worden.</li> <li><code>ORDER BY</code> – gebruikt om de expressie(s) op te geven op basis waarvan de resultaatgegevens gesorteerd moeten worden.</li> <li><code>INTO</code> – gebruikt om de rijen te kopiëren naar een nieuw aan te maken tabel of naar één of meerdere variabelen.</li></ul> <div class="mw-heading mw-heading2"><h2 id="SELECT-syntaxis">SELECT-syntaxis</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Select_(SQL)&veaction=edit&section=2" title="Bewerk dit kopje: SELECT-syntaxis" class="mw-editsection-visualeditor"><span>bewerken</span></a><span class="mw-editsection-divider"> | </span><a href="/w/index.php?title=Select_(SQL)&action=edit&section=2" title="De broncode bewerken van de sectie: SELECT-syntaxis"><span>brontekst bewerken</span></a><span class="mw-editsection-bracket">]</span></span></div> <div class="mw-highlight mw-highlight-lang-sql mw-content-ltr" dir="ltr"><pre><span></span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="k">column_name</span><span class="p">(</span><span class="n">s</span><span class="p">)</span> <span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="k">table_name</span> </pre></div> <p>en </p> <div class="mw-highlight mw-highlight-lang-sql mw-content-ltr" dir="ltr"><pre><span></span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="k">table_name</span> </pre></div> <p>De asterisk (*) wordt gebruikt om snel alle kolommen te selecteren.<sup id="cite_ref-w3schools_1-0" class="reference"><a href="#cite_note-w3schools-1"><span class="cite-bracket">[</span>1<span class="cite-bracket">]</span></a></sup> </p> <div class="mw-heading mw-heading3"><h3 id="CTE">CTE</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Select_(SQL)&veaction=edit&section=3" title="Bewerk dit kopje: CTE" class="mw-editsection-visualeditor"><span>bewerken</span></a><span class="mw-editsection-divider"> | </span><a href="/w/index.php?title=Select_(SQL)&action=edit&section=3" title="De broncode bewerken van de sectie: CTE"><span>brontekst bewerken</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>Common Table Expressions kunnen sinds de SQL-standaard 1999 via het sleutelwoord WITH worden toegevoegd voorafgaand aan een SELECT-opdracht. </p> <div class="mw-heading mw-heading2"><h2 id="Voorbeelden">Voorbeelden</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Select_(SQL)&veaction=edit&section=4" title="Bewerk dit kopje: Voorbeelden" class="mw-editsection-visualeditor"><span>bewerken</span></a><span class="mw-editsection-divider"> | </span><a href="/w/index.php?title=Select_(SQL)&action=edit&section=4" title="De broncode bewerken van de sectie: Voorbeelden"><span>brontekst bewerken</span></a><span class="mw-editsection-bracket">]</span></span></div> <table cellpadding="3" rules="all" align="right" style="float: right; border: 1px solid black; margin-left: 2ex;"> <tbody><tr> <th>Vb. </th> <th>Tabel "T" </th> <th>Query </th> <th>Resultaat </th></tr> <tr> <td align="center">1 > </td> <td align="center"> <table cellpadding="2" rules="all" style="border: 1px solid gray; text-align: center;"> <tbody><tr> <th>K1</th> <th>K2 </th></tr> <tr> <td>1</td> <td>a </td></tr> <tr> <td>2</td> <td>b </td></tr></tbody></table> </td> <td><div class="mw-highlight mw-highlight-lang-sql mw-content-ltr" dir="ltr"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">T</span> </pre></div> </td> <td align="center"> <table cellpadding="2" rules="all" style="border: 1px solid gray; text-align: center;"> <tbody><tr> <th>K1</th> <th>K2 </th></tr> <tr> <td>1</td> <td>a </td></tr> <tr> <td>2</td> <td>b </td></tr></tbody></table> </td></tr> <tr> <td align="center">2 > </td> <td align="center"> <table cellpadding="2" rules="all" style="border: 1px solid gray; text-align: center;"> <tbody><tr> <th>K1</th> <th>K2 </th></tr> <tr> <td>1</td> <td>a </td></tr> <tr> <td>2</td> <td>b </td></tr></tbody></table> </td> <td><div class="mw-highlight mw-highlight-lang-sql mw-content-ltr" dir="ltr"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="n">K1</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">T</span> </pre></div> </td> <td align="center"> <table cellpadding="2" rules="all" style="border: 1px solid gray; text-align: center;"> <tbody><tr> <th>K1 </th></tr> <tr> <td>1 </td></tr> <tr> <td>2 </td></tr></tbody></table> </td></tr> <tr> <td align="center">3 > </td> <td align="center"> <table cellpadding="2" rules="all" style="border: 1px solid gray; text-align: center;"> <tbody><tr> <th>K1</th> <th>K2 </th></tr> <tr> <td>1</td> <td>a </td></tr> <tr> <td>2</td> <td>b </td></tr></tbody></table> </td> <td><div class="mw-highlight mw-highlight-lang-sql mw-content-ltr" dir="ltr"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">T</span><span class="w"> </span><span class="k">WHERE</span><span class="w"> </span><span class="n">K1</span><span class="w"> </span><span class="o">=</span><span class="s1">'1'</span> </pre></div> </td> <td align="center"> <table cellpadding="2" rules="all" style="border: 1px solid gray; text-align: center;"> <tbody><tr> <th>K1</th> <th>K2 </th></tr> <tr> <td>1</td> <td>a </td></tr></tbody></table> </td></tr></tbody></table> <p><b>Voorbeeld 1:</b> </p><p>Gegeven een tabel T zal de query <code>SELECT * FROM T</code> zal alle kolommen, rijen en velden ophalen uit de tabel. </p><p><b>Voorbeeld 2:</b> </p><p>De query <code>SELECT K1 FROM T</code> zal alleen de kolom K1 ophalen en daarvan alle rijen tonen — in <a href="/wiki/Relationele_algebra" title="Relationele algebra">relationele algebra</a> noemt men dit een <i>projectie</i>. </p><p><b>Voorbeeld 3:</b> </p><p>De query <code>SELECT * FROM T WHERE K1 ='1'</code> zal alle kolommen en alle rijen ophalen waarvan de waarde van de kolom K1 gelijk is aan '1' — in relationele algebra heet dit een <i>selectie</i>. </p><p><b>Voorbeeld 4:</b> </p> <div class="mw-highlight mw-highlight-lang-sql mw-content-ltr" dir="ltr"><pre><span></span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">INTO</span><span class="w"> </span><span class="n">nieuwetabel</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">T</span> </pre></div> <p>zal een nieuwe tabel "nieuwetabel" aanmaken en alle rijen van T daarin plaatsen. </p> <div class="mw-heading mw-heading2"><h2 id="Join">Join</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Select_(SQL)&veaction=edit&section=5" title="Bewerk dit kopje: Join" class="mw-editsection-visualeditor"><span>bewerken</span></a><span class="mw-editsection-divider"> | </span><a href="/w/index.php?title=Select_(SQL)&action=edit&section=5" title="De broncode bewerken van de sectie: Join"><span>brontekst bewerken</span></a><span class="mw-editsection-bracket">]</span></span></div> <div class="hatnote" style="margin-bottom:0.5em; padding:0.5em 0 0.5em 1.6em; font-size:95%;" role="note"><span typeof="mw:File"><span><img alt="" src="//upload.wikimedia.org/wikipedia/commons/thumb/e/ee/1rightarrow_blue.svg/15px-1rightarrow_blue.svg.png" decoding="async" width="15" height="15" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/e/ee/1rightarrow_blue.svg/23px-1rightarrow_blue.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/e/ee/1rightarrow_blue.svg/30px-1rightarrow_blue.svg.png 2x" data-file-width="480" data-file-height="480" /></span></span> <i>Zie <a href="/wiki/Join_(SQL)" title="Join (SQL)">Join (SQL)</a> voor het hoofdartikel over dit onderwerp.</i></div> <p>In een <kbd>SELECT</kbd>-opdracht kunnen ook twee <a href="/wiki/Tabel_(database)" title="Tabel (database)">tabellen</a> samengevoegd worden. Dit gaat door middel van een <kbd>JOIN</kbd>. Er zijn twee soorten joins, een inner-join en een outer-join. Een outer-join kan op zijn beurt weer left, right of full zijn. </p><p>Voorbeeld: </p> <div class="mw-highlight mw-highlight-lang-sql mw-content-ltr" dir="ltr"><pre><span></span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">tabel1</span><span class="w"> </span><span class="k">INNER</span><span class="w"> </span><span class="k">JOIN</span><span class="w"> </span><span class="n">tabel2</span><span class="w"> </span><span class="k">ON</span><span class="w"> </span><span class="n">tabel1</span><span class="p">.</span><span class="n">veld</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="n">tabel2</span><span class="p">.</span><span class="n">veld</span> </pre></div> <div class="mw-heading mw-heading2"><h2 id="Zie_ook">Zie ook</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Select_(SQL)&veaction=edit&section=6" title="Bewerk dit kopje: Zie ook" class="mw-editsection-visualeditor"><span>bewerken</span></a><span class="mw-editsection-divider"> | </span><a href="/w/index.php?title=Select_(SQL)&action=edit&section=6" title="De broncode bewerken van de sectie: Zie ook"><span>brontekst bewerken</span></a><span class="mw-editsection-bracket">]</span></span></div> <ul><li><a href="/wiki/SQL" title="SQL">SQL</a></li> <li><a href="/wiki/Delete_(SQL)" title="Delete (SQL)"><kbd>DELETE</kbd></a></li> <li><a href="/wiki/Update_(SQL)" title="Update (SQL)"><kbd>UPDATE</kbd></a></li> <li><a href="/wiki/Insert_(SQL)" title="Insert (SQL)"><kbd>INSERT</kbd></a></li> <li><a href="/w/index.php?title=Copy_(SQL)&action=edit&redlink=1" class="new" title="Copy (SQL) (de pagina bestaat niet)"><kbd>COPY</kbd></a></li></ul> <style data-mw-deduplicate="TemplateStyles:r67837862">.mw-parser-output .navigatie{position:relative;clear:both;overflow:auto;margin:1em auto -0.5em;padding:2px;background-color:var(--background-color-neutral-subtle,#f8f9fa);border:1px solid var(--border-color-base,#a2a9b1);text-align:center;font-size:87%}.mw-parser-output .navigatie-bewerken{margin-left:0.5em}.mw-parser-output .navigatie-bewerken .mw-ui-icon::before{background-size:0.9em}.mw-parser-output .navigatie-afb-links,.mw-parser-output .navigatie-afb-rechts{position:absolute}.mw-parser-output .navigatie-afb-rechts{right:2px}.mw-parser-output .navigatie-afb-groot{float:right;padding-left:0.5em}.mw-parser-output .navigatie-titel{background-color:#ddeef8;padding:2px 5.5em;font-weight:bold}.mw-parser-output .navigatie-inhoud{padding:0.5em}.mw-parser-output .navigatie-inhoud p:first-child{margin:0}.mw-parser-output .navigatie div[style*="background-color"],.mw-parser-output .navigatie div[style*="background"]{color:inherit}@media screen{html.skin-theme-clientpref-night .mw-parser-output .navigatie-titel{background-color:var(--background-color-interactive,#eaecf0)!important}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .navigatie-titel{background-color:var(--background-color-interactive,#eaecf0)!important}}</style> <div class="navigatie" role="navigation" aria-labelledby="Databases"> <div class="navigatie-afb-links noviewer"><div class="navigatie-bewerken show-autoconfirmed nomobile"><span class="nowrap skin-invert-image"><span typeof="mw:File"><a href="/wiki/Sjabloon:Navigatie_databases" title="Sjabloon:Navigatie databases"><img src="//upload.wikimedia.org/wikipedia/commons/thumb/c/c4/OOjs_UI_icon_article-ltr.svg/16px-OOjs_UI_icon_article-ltr.svg.png" decoding="async" width="16" height="16" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/c/c4/OOjs_UI_icon_article-ltr.svg/24px-OOjs_UI_icon_article-ltr.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/c/c4/OOjs_UI_icon_article-ltr.svg/32px-OOjs_UI_icon_article-ltr.svg.png 2x" data-file-width="20" data-file-height="20" /></a></span> · <span typeof="mw:File"><a href="https://en.wikipedia.org/wiki/nl:Overleg_sjabloon:Navigatie_databases" title="Overleg sjabloon"><img alt="Overleg sjabloon" src="//upload.wikimedia.org/wikipedia/commons/thumb/4/40/OOjs_UI_icon_speechBubbles-ltr.svg/16px-OOjs_UI_icon_speechBubbles-ltr.svg.png" decoding="async" width="16" height="16" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/4/40/OOjs_UI_icon_speechBubbles-ltr.svg/24px-OOjs_UI_icon_speechBubbles-ltr.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/4/40/OOjs_UI_icon_speechBubbles-ltr.svg/32px-OOjs_UI_icon_speechBubbles-ltr.svg.png 2x" data-file-width="20" data-file-height="20" /></a></span> · <span typeof="mw:File"><a href="//nl.wikipedia.org/w/index.php?title=Sjabloon:Navigatie_databases&action=edit" title="Sjabloon bewerken"><img alt="Sjabloon bewerken" src="//upload.wikimedia.org/wikipedia/commons/thumb/8/8a/OOjs_UI_icon_edit-ltr.svg/16px-OOjs_UI_icon_edit-ltr.svg.png" decoding="async" width="16" height="16" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/8/8a/OOjs_UI_icon_edit-ltr.svg/24px-OOjs_UI_icon_edit-ltr.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/8/8a/OOjs_UI_icon_edit-ltr.svg/32px-OOjs_UI_icon_edit-ltr.svg.png 2x" data-file-width="20" data-file-height="20" /></a></span></span></div></div> <div id="Databases" class="navigatie-titel">Databases</div> <div class="navigatie-inhoud"> <p><a href="/wiki/Databasemanagementsysteem" title="Databasemanagementsysteem">databasemanagementsysteem</a> · <a href="/wiki/Databasemodel" title="Databasemodel">databasemodel</a> · <a href="/wiki/Databasenormalisatie" title="Databasenormalisatie">databasenormalisatie</a> · <a href="/wiki/Referenti%C3%ABle_integriteit" title="Referentiële integriteit">referentiële integriteit</a> · <a href="/wiki/Relationele_algebra" title="Relationele algebra">relationele algebra</a> · <a href="/wiki/Relationele_database" title="Relationele database">relationele database</a> · <a href="/wiki/Relationeel_model" title="Relationeel model">relationeel model</a> </p> <style data-mw-deduplicate="TemplateStyles:r67785531">.mw-parser-output .navigatie-tabel{margin:0 auto 0 auto;text-align:left}.mw-parser-output .navigatie-tabel .links{text-align:right}.mw-parser-output .navigatie-tabel .rechts{padding-left:0.5em}@media screen and (max-width:640px){.mw-parser-output .navigatie-tabel tr{display:grid;grid-template-columns:1fr;width:100%;margin-bottom:0.5em}.mw-parser-output .navigatie-tabel tr:last-of-type{margin-bottom:0}.mw-parser-output .navigatie-tabel .links{text-align:unset}.mw-parser-output .navigatie-tabel .rechts{padding:unset}}</style><table class="navigatie-tabel vatop" cellpadding="0" cellspacing="0" style=""><tbody><tr><td class="links" style=""><b>Begrippen:</b></td><td class="rechts"><a href="/wiki/Database" title="Database">database</a> · <a href="/wiki/ACID" title="ACID">ACID</a> · <a href="/wiki/CRUD" title="CRUD">CRUD</a> · <a href="/wiki/Null" title="Null">null</a> · <a href="/wiki/Vreemde_sleutel" title="Vreemde sleutel">vreemde sleutel</a> · <a href="/wiki/Primaire_sleutel" title="Primaire sleutel">primaire sleutel</a> · <a href="/wiki/Kandidaatsleutel" title="Kandidaatsleutel">kandidaatsleutel</a> · <a href="/w/index.php?title=Axioma%27s_van_Armstrong&action=edit&redlink=1" class="new" title="Axioma's van Armstrong (de pagina bestaat niet)">axioma's van Armstrong</a></td></tr><tr><td class="links"><b>Objecten:</b></td><td class="rechts"><a href="/wiki/Tabel_(database)" title="Tabel (database)">tabel</a> · <a href="/wiki/Relatie" title="Relatie">relatie</a> · <a href="/w/index.php?title=View_(database)&action=edit&redlink=1" class="new" title="View (database) (de pagina bestaat niet)">view</a> · <a href="/wiki/Transactie_(dataopslag)" title="Transactie (dataopslag)">transactie</a> · <a href="/wiki/Trigger" title="Trigger">trigger</a> · <a href="/wiki/Index_(database)" title="Index (database)">index</a> · <a href="/wiki/Opgeslagen_procedure" title="Opgeslagen procedure">opgeslagen procedure</a> · <a href="/wiki/Cursor" title="Cursor">cursor</a> · <a href="/w/index.php?title=Partitie_(database)&action=edit&redlink=1" class="new" title="Partitie (database) (de pagina bestaat niet)">partitie</a></td></tr><tr><td class="links"><b><a href="/wiki/SQL" title="SQL">SQL</a>:</b></td><td class="rechts"><a class="mw-selflink selflink">Select</a> · <a href="/wiki/Insert_(SQL)" title="Insert (SQL)">Insert</a> · <a href="/wiki/Update_(SQL)" title="Update (SQL)">Update</a> · <a href="/wiki/Merge_(SQL)" title="Merge (SQL)">Merge</a> · <a href="/wiki/Delete_(SQL)" title="Delete (SQL)">Delete</a> · <a href="/wiki/From_(SQL)" title="From (SQL)">From</a> · <a href="/wiki/Join_(SQL)" title="Join (SQL)">Join</a> · <a href="/wiki/Union_(SQL)" title="Union (SQL)">Union</a> · <a href="/wiki/Create_(SQL)" title="Create (SQL)">Create</a> · <a href="/wiki/Drop_(SQL)" title="Drop (SQL)">Drop</a> · <a href="/wiki/Commit" title="Commit">Commit</a> · <a href="/wiki/Rollback_(dataopslag)" title="Rollback (dataopslag)">Rollback</a> · <a href="/wiki/Truncate_(SQL)" title="Truncate (SQL)">Truncate</a> · <a href="/wiki/Alter_(SQL)" title="Alter (SQL)">Alter</a> · <a href="/wiki/Where_(SQL)" title="Where (SQL)">Where</a> · <a href="/wiki/Data_definition_language" title="Data definition language">DDL</a> · <a href="/wiki/Data_manipulation_language" title="Data manipulation language">DML</a> · <a href="/wiki/Data_control_language" title="Data control language">DCL</a></td></tr><tr><td class="links"><b>Producten:</b></td><td class="rechts"><a href="/wiki/Lijst_van_relationele_databases" title="Lijst van relationele databases">relationele databases</a></td></tr></tbody></table> </div></div> <div class="toccolours appendix" role="presentation" style="font-size:90%; margin:1em 0 -0.5em; clear:both;"> <div><span style="font-weight:bold">Bronnen, noten en/of referenties</span></div> <div class="reflist" style="list-style-type: decimal;"><div class="mw-references-wrap"><ol class="references"> <li id="cite_note-w3schools-1"><span class="mw-cite-backlink"><a href="#cite_ref-w3schools_1-0">↑</a></span> <span class="reference-text"><span class="citation" id="CITEREF2011"><a rel="nofollow" class="external text" href="http://www.w3schools.com/sql/sql_select.asp"><b>W3 Schools</b></a> (20-03-2011). </span></span> </li> </ol></div></div> </div>    </div><noscript><img src="https://login.wikimedia.org/wiki/Special:CentralAutoLogin/start?useformat=desktop&type=1x1&usesul3=0" alt="" width="1" height="1" style="border: none; position: absolute;"></noscript> <div class="printfooter" data-nosnippet="">Overgenomen van "<a dir="ltr" href="https://nl.wikipedia.org/w/index.php?title=Select_(SQL)&oldid=68057805">https://nl.wikipedia.org/w/index.php?title=Select_(SQL)&oldid=68057805</a>"</div></div> <div id="catlinks" class="catlinks" data-mw="interface"><div id="mw-normal-catlinks" class="mw-normal-catlinks"><a href="/wiki/Categorie:Alles" title="Categorie:Alles">Categorieën</a>: <ul><li><a href="/wiki/Categorie:SQL" title="Categorie:SQL">SQL</a></li><li><a href="/wiki/Categorie:Relationele_database" title="Categorie:Relationele database">Relationele database</a></li></ul></div></div> </div> </main> </div> <div class="mw-footer-container"> <footer id="footer" class="mw-footer" > <ul id="footer-info"> <li id="footer-info-lastmod"> Deze pagina is voor het laatst bewerkt op 2 sep 2024 om 15:48.</li> <li id="footer-info-copyright">De tekst is beschikbaar onder de licentie <a rel="nofollow" class="external text" href="//creativecommons.org/licenses/by-sa/4.0/deed.nl">Creative Commons Naamsvermelding/Gelijk delen</a>, er kunnen aanvullende voorwaarden van toepassing zijn. Zie de <a class="external text" href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Terms_of_Use/nl">gebruiksvoorwaarden</a> voor meer informatie.<br /> Wikipedia® is een geregistreerd handelsmerk van de <a rel="nofollow" class="external text" href="https://www.wikimediafoundation.org">Wikimedia Foundation, Inc.</a>, een organisatie zonder winstoogmerk.</li> </ul> <ul id="footer-places"> <li id="footer-places-privacy"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacybeleid</a></li> <li id="footer-places-about"><a href="/wiki/Wikipedia">Over Wikipedia</a></li> <li id="footer-places-disclaimers"><a href="/wiki/Wikipedia:Algemeen_voorbehoud">Disclaimers</a></li> <li id="footer-places-wm-codeofconduct"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Universal_Code_of_Conduct">Gedragscode</a></li> <li id="footer-places-developers"><a href="https://developer.wikimedia.org">Ontwikkelaars</a></li> <li id="footer-places-statslink"><a href="https://stats.wikimedia.org/#/nl.wikipedia.org">Statistieken</a></li> <li id="footer-places-cookiestatement"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Cookie_statement">Cookieverklaring</a></li> <li id="footer-places-mobileview"><a href="//nl.m.wikipedia.org/w/index.php?title=Select_(SQL)&mobileaction=toggle_view_mobile" class="noprint stopMobileRedirectToggle">Mobiele weergave</a></li> </ul> <ul id="footer-icons" class="noprint"> <li id="footer-copyrightico"><a href="https://wikimediafoundation.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/static/images/footer/wikimedia-button.svg" width="84" height="29" alt="Wikimedia Foundation" loading="lazy"></a></li> <li id="footer-poweredbyico"><a href="https://www.mediawiki.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/w/resources/assets/poweredby_mediawiki.svg" alt="Powered by MediaWiki" width="88" height="31" loading="lazy"></a></li> </ul> </footer> </div> </div> </div> <div class="vector-settings" id="p-dock-bottom"> <ul></ul> </div><script>(RLQ=window.RLQ||[]).push(function(){mw.config.set({"wgHostname":"mw-web.codfw.main-5ccf8d5c58-5mkmg","wgBackendResponseTime":143,"wgPageParseReport":{"limitreport":{"cputime":"0.089","walltime":"0.718","ppvisitednodes":{"value":769,"limit":1000000},"postexpandincludesize":{"value":10390,"limit":2097152},"templateargumentsize":{"value":4016,"limit":2097152},"expansiondepth":{"value":14,"limit":100},"expensivefunctioncount":{"value":8,"limit":500},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":5829,"limit":5000000},"entityaccesscount":{"value":0,"limit":400},"timingprofile":["100.00% 69.011 1 -total"," 47.59% 32.840 1 Sjabloon:Navigatie_databases"," 43.15% 29.778 1 Sjabloon:Appendix"," 42.14% 29.080 1 Sjabloon:Navigatie"," 39.21% 27.059 1 Sjabloon:References"," 16.23% 11.197 1 Sjabloon:Citeer_web"," 15.75% 10.866 1 Sjabloon:Navigatie/Tabel"," 6.93% 4.782 1 Sjabloon:Zie_hoofdartikel"," 5.71% 3.940 1 Sjabloon:Bewerklinks"," 3.52% 2.431 1 Sjabloon:Sfnref"]},"scribunto":{"limitreport-timeusage":{"value":"0.003","limit":"10.000"},"limitreport-memusage":{"value":625201,"limit":52428800}},"cachereport":{"origin":"mw-web.eqiad.main-67876799fc-k725l","timestamp":"20241127165309","ttl":2592000,"transientcontent":false}}});});</script> <script type="application/ld+json">{"@context":"https:\/\/schema.org","@type":"Article","name":"Select (SQL)","url":"https:\/\/nl.wikipedia.org\/wiki\/Select_(SQL)","sameAs":"http:\/\/www.wikidata.org\/entity\/Q1164001","mainEntity":"http:\/\/www.wikidata.org\/entity\/Q1164001","author":{"@type":"Organization","name":"Bijdragers aan Wikimedia-projecten"},"publisher":{"@type":"Organization","name":"Wikimedia Foundation, Inc.","logo":{"@type":"ImageObject","url":"https:\/\/www.wikimedia.org\/static\/images\/wmf-hor-googpub.png"}},"datePublished":"2005-09-11T07:46:35Z","dateModified":"2024-09-02T14:48:13Z","headline":"SQL"}</script> </body> </html>