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-disabled skin-theme-clientpref-day vector-toc-available" lang="sq" dir="ltr"> <head> <meta charset="UTF-8"> <title>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-disabled skin-theme-clientpref-day vector-toc-available";var cookie=document.cookie.match(/(?:^|; )sqwikimwclientpreferences=([^;]+)/);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":["","janar","shkurt","mars","prill","maj","qershor","korrik","gusht","shtator","tetor","nëntor","dhjetor"],"wgRequestId":"e866d9ed-f1d2-4a71-a766-6ad5056c6039","wgCanonicalNamespace":"","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":0,"wgPageName":"SQL","wgTitle":"SQL","wgCurRevisionId":2615650,"wgRevisionId":2615650,"wgArticleId":83862,"wgIsArticle":true,"wgIsRedirect":false,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":["Përpunim i të dhënave","Database","SQL"],"wgPageViewLanguage":"sq","wgPageContentLanguage":"sq","wgPageContentModel":"wikitext","wgRelevantPageName":"SQL","wgRelevantArticleId":83862,"wgIsProbablyEditable":true,"wgRelevantPageIsProbablyEditable":true,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgNoticeProject":"wikipedia","wgCiteReferencePreviewsActive":true,"wgFlaggedRevsParams":{"tags":{"accuracy":{"levels":2}}},"wgStableRevisionId":2615650,"wgMediaViewerOnClick":true, "wgMediaViewerEnabledByDefault":true,"wgPopupsFlags":0,"wgVisualEditor":{"pageLanguageCode":"sq","pageLanguageDir":"ltr","pageVariantFallbacks":"sq"},"wgMFDisplayWikibaseDescriptions":{"search":true,"watchlist":true,"tagline":true,"nearby":true},"wgWMESchemaEditAttemptStepOversample":false,"wgWMEPageLength":6000,"wgRelatedArticlesCompat":[],"wgCentralAuthMobileDomain":false,"wgEditSubmitButtonLabelPublish":true,"wgULSPosition":"interlanguage","wgULSisCompactLinksEnabled":false,"wgVector2022LanguageInHeader":true,"wgULSisLanguageSelectorEmpty":false,"wgWikibaseItemId":"Q47607","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","skins.vector.search.codex.styles":"ready","skins.vector.styles":"ready","skins.vector.icons":"ready","jquery.makeCollapsible.styles":"ready","ext.flaggedRevs.basic":"ready","mediawiki.codex.messagebox.styles":"ready","ext.wikimediamessages.styles":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","ext.uls.interlanguage":"ready","wikibase.client.init":"ready","ext.wikimediaBadges":"ready"};RLPAGEMODULES=["site","mediawiki.page.ready","jquery.makeCollapsible","mediawiki.toc","skins.vector.js","ext.centralNotice.geoIP","ext.centralNotice.startUp","ext.flaggedRevs.advanced","ext.gadget.lidhjetejashtme","ext.gadget.switcher","ext.urlShortener.toolbar","ext.centralauth.centralautologin","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","wikibase.sidebar.tracking"];</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=sq&modules=ext.flaggedRevs.basic%7Cext.uls.interlanguage%7Cext.visualEditor.desktopArticleTarget.noscript%7Cext.wikimediaBadges%7Cext.wikimediamessages.styles%7Cjquery.makeCollapsible.styles%7Cmediawiki.codex.messagebox.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=sq&modules=startup&only=scripts&raw=1&skin=vector-2022"></script> <meta name="ResourceLoaderDynamicStyles" content=""> <link rel="stylesheet" href="/w/load.php?lang=sq&modules=site.styles&only=styles&skin=vector-2022"> <meta name="generator" content="MediaWiki 1.44.0-wmf.4"> <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="SQL - Wikipedia"> <meta property="og:type" content="website"> <link rel="alternate" media="only screen and (max-width: 640px)" href="//sq.m.wikipedia.org/wiki/SQL"> <link rel="alternate" type="application/x-wiki" title="Redaktoni" href="/w/index.php?title=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 (sq)"> <link rel="EditURI" type="application/rsd+xml" href="//sq.wikipedia.org/w/api.php?action=rsd"> <link rel="canonical" href="https://sq.wikipedia.org/wiki/SQL"> <link rel="license" href="https://creativecommons.org/licenses/by-sa/4.0/deed.sq"> <link rel="alternate" type="application/atom+xml" title="Wikipedia Atom feed" href="/w/index.php?title=Speciale:NdryshimeS%C3%ABFundmi&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-SQL rootpage-SQL skin-vector-2022 action-view"><a class="mw-jump-link" href="#bodyContent">Jump to content</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="Main menu" > <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">Main menu</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">Main menu</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-main-menu.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-main-menu.unpin">fshihe</button> </div> <div id="p-navigation" class="vector-menu mw-portlet mw-portlet-navigation" > <div class="vector-menu-heading"> Lëvizje </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-writearticle" class="mw-list-item"><a href="/wiki/Wikipedia:Ndihm%C3%ABsi_i_Artikujve"><span>Shkruaj një artikull</span></a></li><li id="n-randompage" class="mw-list-item"><a href="/wiki/Speciale:ArtikullIRast%C3%ABsish%C3%ABm" title="Shikoni një artikull të rastit [x]" accesskey="x"><span>Artikull i rastit</span></a></li><li id="n-recentchanges" class="mw-list-item"><a href="/wiki/Speciale:NdryshimeS%C3%ABFundmi" title="Lista e ndryshimeve më të fundit në wiki [r]" accesskey="r"><span>Ndryshimet më të fundit</span></a></li> </ul> </div> </div> <div id="p-content" class="vector-menu mw-portlet mw-portlet-content" > <div class="vector-menu-heading"> Përmbajtja </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-featuredarticles" class="mw-list-item"><a href="/wiki/Wikipedia:Artikuj_t%C3%AB_p%C3%ABrkryer"><span>Artikuj të përkryer</span></a></li><li id="n-goodarticles" class="mw-list-item"><a href="/wiki/Wikipedia:Artikuj_t%C3%AB_mir%C3%AB"><span>Artikuj të mirë</span></a></li> </ul> </div> </div> <div id="p-community" class="vector-menu mw-portlet mw-portlet-community" > <div class="vector-menu-heading"> Komuniteti </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-villagepump" class="mw-list-item"><a href="/wiki/Wikipedia:Kuvendi"><span>Kuvendi</span></a></li><li id="n-FAQ" class="mw-list-item"><a href="/wiki/Ndihm%C3%AB:Pyetje_e_P%C3%ABrgjigje"><span>Pyetje e Përgjigje</span></a></li><li id="n-complaints" class="mw-list-item"><a href="/wiki/Wikipedia:Zyra_e_Ankesave"><span>Zyra e Ankesave</span></a></li><li id="n-administration" class="mw-list-item"><a href="/wiki/Wikipedia:Administrata"><span>Administrata</span></a></li><li id="n-robot" class="mw-list-item"><a href="/wiki/Wikipedia:Robot%C3%ABt"><span>Ofiçina</span></a></li><li id="n-deletion" class="mw-list-item"><a href="/wiki/Wikipedia:Forumi_i_Grisjes"><span>Forumi i Grisjes</span></a></li><li id="n-embassy" class="mw-list-item"><a href="/wiki/Wikipedia:Ambasadat"><span>Ambasadat</span></a></li><li id="n-awards" class="mw-list-item"><a href="/wiki/Wikipedia:%C3%87mimet"><span>Çmimet</span></a></li><li id="n-sandbox" class="mw-list-item"><a href="/wiki/Wikipedia:Livadhi"><span>Livadhi</span></a></li> </ul> </div> </div> </div> </div> </div> </div> </nav> <a href="/wiki/Faqja_kryesore" 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="enciklopedia e lirë" src="/static/images/mobile/copyright/wikipedia-tagline-sq.svg" width="120" height="16" style="width: 7.5em; height: 1em;"> </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/Speciale:K%C3%ABrko" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only search-toggle" title="Kërko Wikipedia [f]" accesskey="f"><span class="vector-icon mw-ui-icon-search mw-ui-icon-wikimedia-search"></span> <span>Kërko</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="Kërko te Wikipedia" aria-label="Kërko te Wikipedia" autocapitalize="sentences" title="Kërko 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="Speciale:Kërko"> </div> <button class="cdx-button cdx-search-input__end-button">Kërko</button> </form> </div> </div> </div> <nav class="vector-user-links vector-user-links-wide" aria-label="Mjete vetjake"> <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="Appearance"> <div id="vector-appearance-dropdown" class="vector-dropdown " title="Change the appearance of the page's font size, width, and color" > <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="Appearance" > <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">Appearance</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="//donate.wikimedia.org/wiki/Special:FundraiserRedirector?utm_source=donate&utm_medium=sidebar&utm_campaign=C13_sq.wikipedia.org&uselang=sq" class=""><span>Dhuroni</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=Speciale:HapLlogari&returnto=SQL" title="Ju rekomandojmë të krijoni një llogari dhe të kyqeni; megjithatë, nuk është e detyrueshme" class=""><span>Krijo llogari</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=Speciale:Hyrja&returnto=SQL" title="Identifikimi nuk është i detyrueshëm, megjithatë ne jua rekomandojmë. [o]" accesskey="o" class=""><span>Hyni</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="More options" > <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="Mjete vetjake" > <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">Mjete vetjake</span> </label> <div class="vector-dropdown-content"> <div id="p-personal" class="vector-menu mw-portlet mw-portlet-personal" title="User menu" > <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="//donate.wikimedia.org/wiki/Special:FundraiserRedirector?utm_source=donate&utm_medium=sidebar&utm_campaign=C13_sq.wikipedia.org&uselang=sq"><span>Dhuroni</span></a></li><li id="pt-contribute" class="mw-list-item"><a href="/wiki/Speciale:Contribute"><span class="vector-icon mw-ui-icon-edit mw-ui-icon-wikimedia-edit"></span> <span>Contribute</span></a></li><li id="pt-createaccount" class="user-links-collapsible-item mw-list-item"><a href="/w/index.php?title=Speciale:HapLlogari&returnto=SQL" title="Ju rekomandojmë të krijoni një llogari dhe të kyqeni; megjithatë, nuk është e detyrueshme"><span class="vector-icon mw-ui-icon-userAdd mw-ui-icon-wikimedia-userAdd"></span> <span>Krijo llogari</span></a></li><li id="pt-login" class="user-links-collapsible-item mw-list-item"><a href="/w/index.php?title=Speciale:Hyrja&returnto=SQL" title="Identifikimi nuk është i detyrueshëm, megjithatë ne jua rekomandojmë. [o]" accesskey="o"><span class="vector-icon mw-ui-icon-logIn mw-ui-icon-wikimedia-logIn"></span> <span>Hyni</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"> Pages for logged out editors <a href="/wiki/Ndihm%C3%AB:Introduction" aria-label="Learn more about editing"><span>learn more</span></a> </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-anontalk" class="mw-list-item"><a href="/wiki/Speciale:DiskutimetVetjake" title="Faqja e diskutimeve të përdoruesve anonim për këtë adresë IP [n]" accesskey="n"><span>Diskutimi</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="Contents" 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">Contents</h2> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-toc.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-toc.unpin">fshihe</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">Fillim</div> </a> </li> <li id="toc-Historia" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Historia"> <div class="vector-toc-text"> <span class="vector-toc-numb">1</span> <span>Historia</span> </div> </a> <ul id="toc-Historia-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Queries" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Queries"> <div class="vector-toc-text"> <span class="vector-toc-numb">2</span> <span>Queries</span> </div> </a> <ul id="toc-Queries-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Sintaksa_SQL,_Elementet_e_gjuhës" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Sintaksa_SQL,_Elementet_e_gjuhës"> <div class="vector-toc-text"> <span class="vector-toc-numb">3</span> <span>Sintaksa SQL, Elementet e gjuhës</span> </div> </a> <ul id="toc-Sintaksa_SQL,_Elementet_e_gjuhës-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Gjuhë_të_tjera_të_ngjashme" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Gjuhë_të_tjera_të_ngjashme"> <div class="vector-toc-text"> <span class="vector-toc-numb">4</span> <span>Gjuhë të tjera të ngjashme</span> </div> </a> <ul id="toc-Gjuhë_të_tjera_të_ngjashme-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Shih_edhe" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Shih_edhe"> <div class="vector-toc-text"> <span class="vector-toc-numb">5</span> <span>Shih edhe</span> </div> </a> <ul id="toc-Shih_edhe-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Lidhje_të_jashtme" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Lidhje_të_jashtme"> <div class="vector-toc-text"> <span class="vector-toc-numb">6</span> <span>Lidhje të jashtme</span> </div> </a> <ul id="toc-Lidhje_të_jashtme-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="Contents" 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="Toggle the table of contents" > <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">Toggle the table of contents</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">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="Go to an article in another language. Available in 85 languages" > <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-85" 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">85 gjuhë</span> </label> <div class="vector-dropdown-content"> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li class="interlanguage-link interwiki-als mw-list-item"><a href="https://als.wikipedia.org/wiki/SQL" title="SQL – gjermanishte zvicerane" lang="gsw" hreflang="gsw" data-title="SQL" data-language-autonym="Alemannisch" data-language-local-name="gjermanishte zvicerane" class="interlanguage-link-target"><span>Alemannisch</span></a></li><li class="interlanguage-link interwiki-ar mw-list-item"><a href="https://ar.wikipedia.org/wiki/%D9%84%D8%BA%D8%A9_%D8%A7%D9%84%D8%A7%D8%B3%D8%AA%D8%B9%D9%84%D8%A7%D9%85%D8%A7%D8%AA_%D8%A7%D9%84%D9%85%D9%87%D9%8A%D9%83%D9%84%D8%A9" title="لغة الاستعلامات المهيكلة – arabisht" lang="ar" hreflang="ar" data-title="لغة الاستعلامات المهيكلة" data-language-autonym="العربية" data-language-local-name="arabisht" class="interlanguage-link-target"><span>العربية</span></a></li><li class="interlanguage-link interwiki-ast mw-list-item"><a href="https://ast.wikipedia.org/wiki/SQL" title="SQL – asturisht" lang="ast" hreflang="ast" data-title="SQL" data-language-autonym="Asturianu" data-language-local-name="asturisht" class="interlanguage-link-target"><span>Asturianu</span></a></li><li class="interlanguage-link interwiki-az mw-list-item"><a href="https://az.wikipedia.org/wiki/SQL" title="SQL – azerbajxhanisht" lang="az" hreflang="az" data-title="SQL" data-language-autonym="Azərbaycanca" data-language-local-name="azerbajxhanisht" class="interlanguage-link-target"><span>Azərbaycanca</span></a></li><li class="interlanguage-link interwiki-bar mw-list-item"><a href="https://bar.wikipedia.org/wiki/SQL" title="SQL – Bavarian" lang="bar" hreflang="bar" data-title="SQL" data-language-autonym="Boarisch" data-language-local-name="Bavarian" class="interlanguage-link-target"><span>Boarisch</span></a></li><li class="interlanguage-link interwiki-be mw-list-item"><a href="https://be.wikipedia.org/wiki/SQL" title="SQL – bjellorusisht" lang="be" hreflang="be" data-title="SQL" data-language-autonym="Беларуская" data-language-local-name="bjellorusisht" class="interlanguage-link-target"><span>Беларуская</span></a></li><li class="interlanguage-link interwiki-be-x-old mw-list-item"><a href="https://be-tarask.wikipedia.org/wiki/SQL" title="SQL – Belarusian (Taraškievica orthography)" lang="be-tarask" hreflang="be-tarask" data-title="SQL" data-language-autonym="Беларуская (тарашкевіца)" data-language-local-name="Belarusian (Taraškievica orthography)" class="interlanguage-link-target"><span>Беларуская (тарашкевіца)</span></a></li><li class="interlanguage-link interwiki-bg mw-list-item"><a href="https://bg.wikipedia.org/wiki/SQL" title="SQL – bullgarisht" lang="bg" hreflang="bg" data-title="SQL" data-language-autonym="Български" data-language-local-name="bullgarisht" class="interlanguage-link-target"><span>Български</span></a></li><li class="interlanguage-link interwiki-bn mw-list-item"><a href="https://bn.wikipedia.org/wiki/%E0%A6%8F%E0%A6%B8%E0%A6%95%E0%A6%BF%E0%A6%89%E0%A6%8F%E0%A6%B2" title="এসকিউএল – bengalisht" lang="bn" hreflang="bn" data-title="এসকিউএল" data-language-autonym="বাংলা" data-language-local-name="bengalisht" class="interlanguage-link-target"><span>বাংলা</span></a></li><li class="interlanguage-link interwiki-br mw-list-item"><a href="https://br.wikipedia.org/wiki/SQL" title="SQL – bretonisht" lang="br" hreflang="br" data-title="SQL" data-language-autonym="Brezhoneg" data-language-local-name="bretonisht" class="interlanguage-link-target"><span>Brezhoneg</span></a></li><li class="interlanguage-link interwiki-bs mw-list-item"><a href="https://bs.wikipedia.org/wiki/SQL" title="SQL – boshnjakisht" lang="bs" hreflang="bs" data-title="SQL" data-language-autonym="Bosanski" data-language-local-name="boshnjakisht" class="interlanguage-link-target"><span>Bosanski</span></a></li><li class="interlanguage-link interwiki-ca mw-list-item"><a href="https://ca.wikipedia.org/wiki/Structured_Query_Language" title="Structured Query Language – katalonisht" lang="ca" hreflang="ca" data-title="Structured Query Language" data-language-autonym="Català" data-language-local-name="katalonisht" class="interlanguage-link-target"><span>Català</span></a></li><li class="interlanguage-link interwiki-cdo mw-list-item"><a href="https://cdo.wikipedia.org/wiki/SQL" title="SQL – Mindong" lang="cdo" hreflang="cdo" data-title="SQL" data-language-autonym="閩東語 / Mìng-dĕ̤ng-ngṳ̄" data-language-local-name="Mindong" class="interlanguage-link-target"><span>閩東語 / Mìng-dĕ̤ng-ngṳ̄</span></a></li><li class="interlanguage-link interwiki-cs mw-list-item"><a href="https://cs.wikipedia.org/wiki/SQL" title="SQL – çekisht" lang="cs" hreflang="cs" data-title="SQL" data-language-autonym="Čeština" data-language-local-name="çekisht" class="interlanguage-link-target"><span>Čeština</span></a></li><li class="interlanguage-link interwiki-cy mw-list-item"><a href="https://cy.wikipedia.org/wiki/SQL" title="SQL – uellsisht" lang="cy" hreflang="cy" data-title="SQL" data-language-autonym="Cymraeg" data-language-local-name="uellsisht" class="interlanguage-link-target"><span>Cymraeg</span></a></li><li class="interlanguage-link interwiki-da mw-list-item"><a href="https://da.wikipedia.org/wiki/Structured_Query_Language" title="Structured Query Language – danisht" lang="da" hreflang="da" data-title="Structured Query Language" data-language-autonym="Dansk" data-language-local-name="danisht" class="interlanguage-link-target"><span>Dansk</span></a></li><li class="interlanguage-link interwiki-de mw-list-item"><a href="https://de.wikipedia.org/wiki/SQL" title="SQL – gjermanisht" lang="de" hreflang="de" data-title="SQL" data-language-autonym="Deutsch" data-language-local-name="gjermanisht" class="interlanguage-link-target"><span>Deutsch</span></a></li><li class="interlanguage-link interwiki-el mw-list-item"><a href="https://el.wikipedia.org/wiki/SQL" title="SQL – greqisht" lang="el" hreflang="el" data-title="SQL" data-language-autonym="Ελληνικά" data-language-local-name="greqisht" class="interlanguage-link-target"><span>Ελληνικά</span></a></li><li class="interlanguage-link interwiki-en mw-list-item"><a href="https://en.wikipedia.org/wiki/SQL" title="SQL – anglisht" lang="en" hreflang="en" data-title="SQL" data-language-autonym="English" data-language-local-name="anglisht" class="interlanguage-link-target"><span>English</span></a></li><li class="interlanguage-link interwiki-eo mw-list-item"><a href="https://eo.wikipedia.org/wiki/SQL" title="SQL – esperanto" lang="eo" hreflang="eo" data-title="SQL" data-language-autonym="Esperanto" data-language-local-name="esperanto" class="interlanguage-link-target"><span>Esperanto</span></a></li><li class="interlanguage-link interwiki-es mw-list-item"><a href="https://es.wikipedia.org/wiki/SQL" title="SQL – spanjisht" lang="es" hreflang="es" data-title="SQL" data-language-autonym="Español" data-language-local-name="spanjisht" class="interlanguage-link-target"><span>Español</span></a></li><li class="interlanguage-link interwiki-et mw-list-item"><a href="https://et.wikipedia.org/wiki/Struktuurp%C3%A4ringukeel" title="Struktuurpäringukeel – estonisht" lang="et" hreflang="et" data-title="Struktuurpäringukeel" data-language-autonym="Eesti" data-language-local-name="estonisht" class="interlanguage-link-target"><span>Eesti</span></a></li><li class="interlanguage-link interwiki-eu mw-list-item"><a href="https://eu.wikipedia.org/wiki/SQL" title="SQL – baskisht" lang="eu" hreflang="eu" data-title="SQL" data-language-autonym="Euskara" data-language-local-name="baskisht" class="interlanguage-link-target"><span>Euskara</span></a></li><li class="interlanguage-link interwiki-fa mw-list-item"><a href="https://fa.wikipedia.org/wiki/%D8%A7%D8%B3%E2%80%8C%DA%A9%DB%8C%D9%88%D8%A7%D9%84" title="اس‌کیوال – persisht" lang="fa" hreflang="fa" data-title="اس‌کیوال" data-language-autonym="فارسی" data-language-local-name="persisht" class="interlanguage-link-target"><span>فارسی</span></a></li><li class="interlanguage-link interwiki-fi mw-list-item"><a href="https://fi.wikipedia.org/wiki/SQL" title="SQL – finlandisht" lang="fi" hreflang="fi" data-title="SQL" data-language-autonym="Suomi" data-language-local-name="finlandisht" class="interlanguage-link-target"><span>Suomi</span></a></li><li class="interlanguage-link interwiki-fr mw-list-item"><a href="https://fr.wikipedia.org/wiki/Structured_Query_Language" title="Structured Query Language – frëngjisht" lang="fr" hreflang="fr" data-title="Structured Query Language" data-language-autonym="Français" data-language-local-name="frëngjisht" class="interlanguage-link-target"><span>Français</span></a></li><li class="interlanguage-link interwiki-ga mw-list-item"><a href="https://ga.wikipedia.org/wiki/Teanga_Strucht%C3%BArtha_Iarratas" title="Teanga Struchtúrtha Iarratas – irlandisht" lang="ga" hreflang="ga" data-title="Teanga Struchtúrtha Iarratas" data-language-autonym="Gaeilge" data-language-local-name="irlandisht" class="interlanguage-link-target"><span>Gaeilge</span></a></li><li class="interlanguage-link interwiki-gl mw-list-item"><a href="https://gl.wikipedia.org/wiki/SQL" title="SQL – galicisht" lang="gl" hreflang="gl" data-title="SQL" data-language-autonym="Galego" data-language-local-name="galicisht" class="interlanguage-link-target"><span>Galego</span></a></li><li class="interlanguage-link interwiki-hak mw-list-item"><a href="https://hak.wikipedia.org/wiki/SQL" title="SQL – Hakka Chinese" lang="hak" hreflang="hak" data-title="SQL" data-language-autonym="客家語 / Hak-kâ-ngî" data-language-local-name="Hakka Chinese" class="interlanguage-link-target"><span>客家語 / Hak-kâ-ngî</span></a></li><li class="interlanguage-link interwiki-he mw-list-item"><a href="https://he.wikipedia.org/wiki/SQL" title="SQL – hebraisht" lang="he" hreflang="he" data-title="SQL" data-language-autonym="עברית" data-language-local-name="hebraisht" class="interlanguage-link-target"><span>עברית</span></a></li><li class="interlanguage-link interwiki-hi mw-list-item"><a href="https://hi.wikipedia.org/wiki/%E0%A4%8D%E0%A4%B8%E0%A4%95%E0%A5%8D%E0%A4%AF%E0%A5%82%E0%A4%8D%E0%A4%B2" title="ऍसक्यूऍल – indisht" lang="hi" hreflang="hi" data-title="ऍसक्यूऍल" data-language-autonym="हिन्दी" data-language-local-name="indisht" class="interlanguage-link-target"><span>हिन्दी</span></a></li><li class="interlanguage-link interwiki-hr mw-list-item"><a href="https://hr.wikipedia.org/wiki/SQL" title="SQL – kroatisht" lang="hr" hreflang="hr" data-title="SQL" data-language-autonym="Hrvatski" data-language-local-name="kroatisht" class="interlanguage-link-target"><span>Hrvatski</span></a></li><li class="interlanguage-link interwiki-hu mw-list-item"><a href="https://hu.wikipedia.org/wiki/SQL" title="SQL – hungarisht" lang="hu" hreflang="hu" data-title="SQL" data-language-autonym="Magyar" data-language-local-name="hungarisht" class="interlanguage-link-target"><span>Magyar</span></a></li><li class="interlanguage-link interwiki-hy mw-list-item"><a href="https://hy.wikipedia.org/wiki/SQL" title="SQL – armenisht" lang="hy" hreflang="hy" data-title="SQL" data-language-autonym="Հայերեն" data-language-local-name="armenisht" class="interlanguage-link-target"><span>Հայերեն</span></a></li><li class="interlanguage-link interwiki-ia mw-list-item"><a href="https://ia.wikipedia.org/wiki/SQL" title="SQL – interlingua" lang="ia" hreflang="ia" data-title="SQL" data-language-autonym="Interlingua" data-language-local-name="interlingua" class="interlanguage-link-target"><span>Interlingua</span></a></li><li class="interlanguage-link interwiki-id mw-list-item"><a href="https://id.wikipedia.org/wiki/SQL" title="SQL – indonezisht" lang="id" hreflang="id" data-title="SQL" data-language-autonym="Bahasa Indonesia" data-language-local-name="indonezisht" class="interlanguage-link-target"><span>Bahasa Indonesia</span></a></li><li class="interlanguage-link interwiki-is mw-list-item"><a href="https://is.wikipedia.org/wiki/SQL" title="SQL – islandisht" lang="is" hreflang="is" data-title="SQL" data-language-autonym="Íslenska" data-language-local-name="islandisht" class="interlanguage-link-target"><span>Íslenska</span></a></li><li class="interlanguage-link interwiki-it mw-list-item"><a href="https://it.wikipedia.org/wiki/Structured_Query_Language" title="Structured Query Language – italisht" lang="it" hreflang="it" data-title="Structured Query Language" data-language-autonym="Italiano" data-language-local-name="italisht" class="interlanguage-link-target"><span>Italiano</span></a></li><li class="interlanguage-link interwiki-ja mw-list-item"><a href="https://ja.wikipedia.org/wiki/SQL" title="SQL – japonisht" lang="ja" hreflang="ja" data-title="SQL" data-language-autonym="日本語" data-language-local-name="japonisht" class="interlanguage-link-target"><span>日本語</span></a></li><li class="interlanguage-link interwiki-ka mw-list-item"><a href="https://ka.wikipedia.org/wiki/SQL" title="SQL – gjeorgjisht" lang="ka" hreflang="ka" data-title="SQL" data-language-autonym="ქართული" data-language-local-name="gjeorgjisht" class="interlanguage-link-target"><span>ქართული</span></a></li><li class="interlanguage-link interwiki-kk mw-list-item"><a href="https://kk.wikipedia.org/wiki/SQL" title="SQL – kazakisht" lang="kk" hreflang="kk" data-title="SQL" data-language-autonym="Қазақша" data-language-local-name="kazakisht" class="interlanguage-link-target"><span>Қазақша</span></a></li><li class="interlanguage-link interwiki-ko mw-list-item"><a href="https://ko.wikipedia.org/wiki/SQL" title="SQL – koreanisht" lang="ko" hreflang="ko" data-title="SQL" data-language-autonym="한국어" data-language-local-name="koreanisht" class="interlanguage-link-target"><span>한국어</span></a></li><li class="interlanguage-link interwiki-ku mw-list-item"><a href="https://ku.wikipedia.org/wiki/SQL" title="SQL – kurdisht" lang="ku" hreflang="ku" data-title="SQL" data-language-autonym="Kurdî" data-language-local-name="kurdisht" class="interlanguage-link-target"><span>Kurdî</span></a></li><li class="interlanguage-link interwiki-ky mw-list-item"><a href="https://ky.wikipedia.org/wiki/SQL" title="SQL – kirgizisht" lang="ky" hreflang="ky" data-title="SQL" data-language-autonym="Кыргызча" data-language-local-name="kirgizisht" class="interlanguage-link-target"><span>Кыргызча</span></a></li><li class="interlanguage-link interwiki-la mw-list-item"><a href="https://la.wikipedia.org/wiki/SQL" title="SQL – latinisht" lang="la" hreflang="la" data-title="SQL" data-language-autonym="Latina" data-language-local-name="latinisht" class="interlanguage-link-target"><span>Latina</span></a></li><li class="interlanguage-link interwiki-lmo mw-list-item"><a href="https://lmo.wikipedia.org/wiki/Structured_Query_Language" title="Structured Query Language – lombardisht" lang="lmo" hreflang="lmo" data-title="Structured Query Language" data-language-autonym="Lombard" data-language-local-name="lombardisht" class="interlanguage-link-target"><span>Lombard</span></a></li><li class="interlanguage-link interwiki-lt mw-list-item"><a href="https://lt.wikipedia.org/wiki/SQL" title="SQL – lituanisht" lang="lt" hreflang="lt" data-title="SQL" data-language-autonym="Lietuvių" data-language-local-name="lituanisht" class="interlanguage-link-target"><span>Lietuvių</span></a></li><li class="interlanguage-link interwiki-lv mw-list-item"><a href="https://lv.wikipedia.org/wiki/SQL" title="SQL – letonisht" lang="lv" hreflang="lv" data-title="SQL" data-language-autonym="Latviešu" data-language-local-name="letonisht" class="interlanguage-link-target"><span>Latviešu</span></a></li><li class="interlanguage-link interwiki-mhr mw-list-item"><a href="https://mhr.wikipedia.org/wiki/SQL" title="SQL – Eastern Mari" lang="mhr" hreflang="mhr" data-title="SQL" data-language-autonym="Олык марий" data-language-local-name="Eastern Mari" class="interlanguage-link-target"><span>Олык марий</span></a></li><li class="interlanguage-link interwiki-mk mw-list-item"><a href="https://mk.wikipedia.org/wiki/SQL" title="SQL – maqedonisht" lang="mk" hreflang="mk" data-title="SQL" data-language-autonym="Македонски" data-language-local-name="maqedonisht" class="interlanguage-link-target"><span>Македонски</span></a></li><li class="interlanguage-link interwiki-ml mw-list-item"><a href="https://ml.wikipedia.org/wiki/%E0%B4%8E%E0%B4%B8%E0%B5%8D.%E0%B4%95%E0%B5%8D%E0%B4%AF%E0%B5%81.%E0%B4%8E%E0%B5%BD." title="എസ്.ക്യു.എൽ. – malajalamisht" lang="ml" hreflang="ml" data-title="എസ്.ക്യു.എൽ." data-language-autonym="മലയാളം" data-language-local-name="malajalamisht" class="interlanguage-link-target"><span>മലയാളം</span></a></li><li class="interlanguage-link interwiki-ms mw-list-item"><a href="https://ms.wikipedia.org/wiki/SQL" title="SQL – malajisht" lang="ms" hreflang="ms" data-title="SQL" data-language-autonym="Bahasa Melayu" data-language-local-name="malajisht" class="interlanguage-link-target"><span>Bahasa Melayu</span></a></li><li class="interlanguage-link interwiki-my mw-list-item"><a href="https://my.wikipedia.org/wiki/SQL" title="SQL – birmanisht" lang="my" hreflang="my" data-title="SQL" data-language-autonym="မြန်မာဘာသာ" data-language-local-name="birmanisht" class="interlanguage-link-target"><span>မြန်မာဘာသာ</span></a></li><li class="interlanguage-link interwiki-nl mw-list-item"><a href="https://nl.wikipedia.org/wiki/SQL" title="SQL – holandisht" lang="nl" hreflang="nl" data-title="SQL" data-language-autonym="Nederlands" data-language-local-name="holandisht" class="interlanguage-link-target"><span>Nederlands</span></a></li><li class="interlanguage-link interwiki-nn mw-list-item"><a href="https://nn.wikipedia.org/wiki/SQL" title="SQL – norvegjishte nynorsk" lang="nn" hreflang="nn" data-title="SQL" data-language-autonym="Norsk nynorsk" data-language-local-name="norvegjishte nynorsk" class="interlanguage-link-target"><span>Norsk nynorsk</span></a></li><li class="interlanguage-link interwiki-no mw-list-item"><a href="https://no.wikipedia.org/wiki/Structured_Query_Language" title="Structured Query Language – norvegjishte letrare" lang="nb" hreflang="nb" data-title="Structured Query Language" data-language-autonym="Norsk bokmål" data-language-local-name="norvegjishte letrare" class="interlanguage-link-target"><span>Norsk bokmål</span></a></li><li class="interlanguage-link interwiki-pa mw-list-item"><a href="https://pa.wikipedia.org/wiki/%E0%A8%90%E0%A9%B1%E0%A8%B8.%E0%A8%95%E0%A8%BF%E0%A8%8A.%E0%A8%90%E0%A9%B1%E0%A8%B2" title="ਐੱਸ.ਕਿਊ.ਐੱਲ – punxhabisht" lang="pa" hreflang="pa" data-title="ਐੱਸ.ਕਿਊ.ਐੱਲ" data-language-autonym="ਪੰਜਾਬੀ" data-language-local-name="punxhabisht" class="interlanguage-link-target"><span>ਪੰਜਾਬੀ</span></a></li><li class="interlanguage-link interwiki-pl mw-list-item"><a href="https://pl.wikipedia.org/wiki/SQL" title="SQL – polonisht" lang="pl" hreflang="pl" data-title="SQL" data-language-autonym="Polski" data-language-local-name="polonisht" class="interlanguage-link-target"><span>Polski</span></a></li><li class="interlanguage-link interwiki-pnb mw-list-item"><a href="https://pnb.wikipedia.org/wiki/%D8%A7%DB%8C%D8%B3_%DA%A9%DB%8C%D9%88_%D8%A7%DB%8C%D9%84" title="ایس کیو ایل – Western Punjabi" lang="pnb" hreflang="pnb" data-title="ایس کیو ایل" data-language-autonym="پنجابی" data-language-local-name="Western Punjabi" class="interlanguage-link-target"><span>پنجابی</span></a></li><li class="interlanguage-link interwiki-pt mw-list-item"><a href="https://pt.wikipedia.org/wiki/SQL" title="SQL – portugalisht" lang="pt" hreflang="pt" data-title="SQL" data-language-autonym="Português" data-language-local-name="portugalisht" class="interlanguage-link-target"><span>Português</span></a></li><li class="interlanguage-link interwiki-qu mw-list-item"><a href="https://qu.wikipedia.org/wiki/SQL" title="SQL – keçuaisht" lang="qu" hreflang="qu" data-title="SQL" data-language-autonym="Runa Simi" data-language-local-name="keçuaisht" class="interlanguage-link-target"><span>Runa Simi</span></a></li><li class="interlanguage-link interwiki-ro mw-list-item"><a href="https://ro.wikipedia.org/wiki/SQL" title="SQL – rumanisht" lang="ro" hreflang="ro" data-title="SQL" data-language-autonym="Română" data-language-local-name="rumanisht" class="interlanguage-link-target"><span>Română</span></a></li><li class="interlanguage-link interwiki-ru mw-list-item"><a href="https://ru.wikipedia.org/wiki/SQL" title="SQL – rusisht" lang="ru" hreflang="ru" data-title="SQL" data-language-autonym="Русский" data-language-local-name="rusisht" class="interlanguage-link-target"><span>Русский</span></a></li><li class="interlanguage-link interwiki-sh mw-list-item"><a href="https://sh.wikipedia.org/wiki/SQL" title="SQL – serbo-kroatisht" lang="sh" hreflang="sh" data-title="SQL" data-language-autonym="Srpskohrvatski / српскохрватски" data-language-local-name="serbo-kroatisht" class="interlanguage-link-target"><span>Srpskohrvatski / српскохрватски</span></a></li><li class="interlanguage-link interwiki-simple mw-list-item"><a href="https://simple.wikipedia.org/wiki/Structured_Query_Language" title="Structured Query Language – Simple English" lang="en-simple" hreflang="en-simple" data-title="Structured Query Language" data-language-autonym="Simple English" data-language-local-name="Simple English" class="interlanguage-link-target"><span>Simple English</span></a></li><li class="interlanguage-link interwiki-sk mw-list-item"><a href="https://sk.wikipedia.org/wiki/Structured_Query_Language" title="Structured Query Language – sllovakisht" lang="sk" hreflang="sk" data-title="Structured Query Language" data-language-autonym="Slovenčina" data-language-local-name="sllovakisht" class="interlanguage-link-target"><span>Slovenčina</span></a></li><li class="interlanguage-link interwiki-sl mw-list-item"><a href="https://sl.wikipedia.org/wiki/SQL" title="SQL – sllovenisht" lang="sl" hreflang="sl" data-title="SQL" data-language-autonym="Slovenščina" data-language-local-name="sllovenisht" class="interlanguage-link-target"><span>Slovenščina</span></a></li><li class="interlanguage-link interwiki-sr mw-list-item"><a href="https://sr.wikipedia.org/wiki/SQL" title="SQL – serbisht" lang="sr" hreflang="sr" data-title="SQL" data-language-autonym="Српски / srpski" data-language-local-name="serbisht" class="interlanguage-link-target"><span>Српски / srpski</span></a></li><li class="interlanguage-link interwiki-sv mw-list-item"><a href="https://sv.wikipedia.org/wiki/Structured_Query_Language" title="Structured Query Language – suedisht" lang="sv" hreflang="sv" data-title="Structured Query Language" data-language-autonym="Svenska" data-language-local-name="suedisht" class="interlanguage-link-target"><span>Svenska</span></a></li><li class="interlanguage-link interwiki-ta mw-list-item"><a href="https://ta.wikipedia.org/wiki/%E0%AE%95%E0%AE%9F%E0%AF%8D%E0%AE%9F%E0%AE%AE%E0%AF%88%E0%AE%AA%E0%AF%8D%E0%AE%AA%E0%AF%81%E0%AE%B3%E0%AF%8D%E0%AE%B3_%E0%AE%B5%E0%AE%BF%E0%AE%A9%E0%AE%B5%E0%AF%81_%E0%AE%AE%E0%AF%8A%E0%AE%B4%E0%AE%BF" title="கட்டமைப்புள்ள வினவு மொழி – tamilisht" lang="ta" hreflang="ta" data-title="கட்டமைப்புள்ள வினவு மொழி" data-language-autonym="தமிழ்" data-language-local-name="tamilisht" class="interlanguage-link-target"><span>தமிழ்</span></a></li><li class="interlanguage-link interwiki-tet mw-list-item"><a href="https://tet.wikipedia.org/wiki/SQL" title="SQL – tetumisht" lang="tet" hreflang="tet" data-title="SQL" data-language-autonym="Tetun" data-language-local-name="tetumisht" class="interlanguage-link-target"><span>Tetun</span></a></li><li class="interlanguage-link interwiki-tg mw-list-item"><a href="https://tg.wikipedia.org/wiki/SQL" title="SQL – taxhikisht" lang="tg" hreflang="tg" data-title="SQL" data-language-autonym="Тоҷикӣ" data-language-local-name="taxhikisht" class="interlanguage-link-target"><span>Тоҷикӣ</span></a></li><li class="interlanguage-link interwiki-th mw-list-item"><a href="https://th.wikipedia.org/wiki/%E0%B8%A0%E0%B8%B2%E0%B8%A9%E0%B8%B2%E0%B8%AA%E0%B8%AD%E0%B8%9A%E0%B8%96%E0%B8%B2%E0%B8%A1%E0%B9%80%E0%B8%8A%E0%B8%B4%E0%B8%87%E0%B9%82%E0%B8%84%E0%B8%A3%E0%B8%87%E0%B8%AA%E0%B8%A3%E0%B9%89%E0%B8%B2%E0%B8%87" title="ภาษาสอบถามเชิงโครงสร้าง – tajlandisht" lang="th" hreflang="th" data-title="ภาษาสอบถามเชิงโครงสร้าง" data-language-autonym="ไทย" data-language-local-name="tajlandisht" class="interlanguage-link-target"><span>ไทย</span></a></li><li class="interlanguage-link interwiki-tl mw-list-item"><a href="https://tl.wikipedia.org/wiki/SQL" title="SQL – Tagalog" lang="tl" hreflang="tl" data-title="SQL" data-language-autonym="Tagalog" data-language-local-name="Tagalog" class="interlanguage-link-target"><span>Tagalog</span></a></li><li class="interlanguage-link interwiki-tr mw-list-item"><a href="https://tr.wikipedia.org/wiki/SQL" title="SQL – turqisht" lang="tr" hreflang="tr" data-title="SQL" data-language-autonym="Türkçe" data-language-local-name="turqisht" class="interlanguage-link-target"><span>Türkçe</span></a></li><li class="interlanguage-link interwiki-tt mw-list-item"><a href="https://tt.wikipedia.org/wiki/SQL" title="SQL – tatarisht" lang="tt" hreflang="tt" data-title="SQL" data-language-autonym="Татарча / tatarça" data-language-local-name="tatarisht" class="interlanguage-link-target"><span>Татарча / tatarça</span></a></li><li class="interlanguage-link interwiki-uk mw-list-item"><a href="https://uk.wikipedia.org/wiki/SQL" title="SQL – ukrainisht" lang="uk" hreflang="uk" data-title="SQL" data-language-autonym="Українська" data-language-local-name="ukrainisht" class="interlanguage-link-target"><span>Українська</span></a></li><li class="interlanguage-link interwiki-ur mw-list-item"><a href="https://ur.wikipedia.org/wiki/%D8%A7%DB%8C%D8%B3_%DA%A9%DB%8C%D9%88_%D8%A7%DB%8C%D9%84" title="ایس کیو ایل – urduisht" lang="ur" hreflang="ur" data-title="ایس کیو ایل" data-language-autonym="اردو" data-language-local-name="urduisht" class="interlanguage-link-target"><span>اردو</span></a></li><li class="interlanguage-link interwiki-uz mw-list-item"><a href="https://uz.wikipedia.org/wiki/SQL" title="SQL – uzbekisht" lang="uz" hreflang="uz" data-title="SQL" data-language-autonym="Oʻzbekcha / ўзбекча" data-language-local-name="uzbekisht" class="interlanguage-link-target"><span>Oʻzbekcha / ўзбекча</span></a></li><li class="interlanguage-link interwiki-vi mw-list-item"><a href="https://vi.wikipedia.org/wiki/SQL" title="SQL – vietnamisht" lang="vi" hreflang="vi" data-title="SQL" data-language-autonym="Tiếng Việt" data-language-local-name="vietnamisht" class="interlanguage-link-target"><span>Tiếng Việt</span></a></li><li class="interlanguage-link interwiki-wuu mw-list-item"><a href="https://wuu.wikipedia.org/wiki/SQL" title="SQL – kinezishte vu" lang="wuu" hreflang="wuu" data-title="SQL" data-language-autonym="吴语" data-language-local-name="kinezishte vu" class="interlanguage-link-target"><span>吴语</span></a></li><li class="interlanguage-link interwiki-yo mw-list-item"><a href="https://yo.wikipedia.org/wiki/SQL" title="SQL – jorubaisht" lang="yo" hreflang="yo" data-title="SQL" data-language-autonym="Yorùbá" data-language-local-name="jorubaisht" class="interlanguage-link-target"><span>Yorùbá</span></a></li><li class="interlanguage-link interwiki-zh mw-list-item"><a href="https://zh.wikipedia.org/wiki/SQL" title="SQL – kinezisht" lang="zh" hreflang="zh" data-title="SQL" data-language-autonym="中文" data-language-local-name="kinezisht" class="interlanguage-link-target"><span>中文</span></a></li><li class="interlanguage-link interwiki-zh-min-nan mw-list-item"><a href="https://zh-min-nan.wikipedia.org/wiki/SQL" title="SQL – Minnan" lang="nan" hreflang="nan" data-title="SQL" data-language-autonym="閩南語 / Bân-lâm-gú" data-language-local-name="Minnan" class="interlanguage-link-target"><span>閩南語 / Bân-lâm-gú</span></a></li><li class="interlanguage-link interwiki-zh-yue mw-list-item"><a href="https://zh-yue.wikipedia.org/wiki/SQL" title="SQL – kantonezisht" lang="yue" hreflang="yue" data-title="SQL" data-language-autonym="粵語" data-language-local-name="kantonezisht" 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/Q47607#sitelinks-wikipedia" title="Përpunoni lidhje ndërgjuhësore" class="wbc-editpage">Përpunoni lidhje</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="Emërhapësira"> <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/SQL" title="Shikoni përmbajtjen e atikullit. [c]" accesskey="c"><span>Artikulli</span></a></li><li id="ca-talk" class="vector-tab-noicon mw-list-item"><a href="/wiki/Diskutim:SQL" rel="discussion" title="Diskutim për përmbajtjen e faqes [t]" accesskey="t"><span>Diskutim</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="Change language variant" > <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">shqip</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="Shikime"> <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/SQL"><span>Lexo</span></a></li><li id="ca-ve-edit" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=SQL&veaction=edit" title="Përpunoni këtë faqe [v]" accesskey="v"><span>Redakto</span></a></li><li id="ca-edit" class="collapsible vector-tab-noicon mw-list-item"><a href="/w/index.php?title=SQL&action=edit" title="Përpunoni kodin burim të kësaj faqeje [e]" accesskey="e"><span>Redakto nëpërmjet kodit</span></a></li><li id="ca-history" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=SQL&action=history" title="Versione të mëparshme të artikullit. [h]" accesskey="h"><span>Shihni historikun</span></a></li> </ul> </div> </div> </nav> <nav class="vector-page-tools-landmark" aria-label="Page tools"> <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="Mjete" > <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">Mjete</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">Mjete</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-page-tools.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-page-tools.unpin">fshihe</button> </div> <div id="p-cactions" class="vector-menu mw-portlet mw-portlet-cactions emptyPortlet vector-has-collapsible-items" title="More options" > <div class="vector-menu-heading"> Actions </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/SQL"><span>Lexo</span></a></li><li id="ca-more-ve-edit" class="vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=SQL&veaction=edit" title="Përpunoni këtë faqe [v]" accesskey="v"><span>Redakto</span></a></li><li id="ca-more-edit" class="collapsible vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=SQL&action=edit" title="Përpunoni kodin burim të kësaj faqeje [e]" accesskey="e"><span>Redakto nëpërmjet kodit</span></a></li><li id="ca-more-history" class="vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=SQL&action=history"><span>Shihni historikun</span></a></li> </ul> </div> </div> <div id="p-tb" class="vector-menu mw-portlet mw-portlet-tb" > <div class="vector-menu-heading"> Të përgjithshme </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-whatlinkshere" class="mw-list-item"><a href="/wiki/Speciale:LidhjetK%C3%ABtu/SQL" title="Lista e të gjitha faqeve wiki që lidhen tek kjo faqe [j]" accesskey="j"><span>Lidhjet këtu</span></a></li><li id="t-recentchangeslinked" class="mw-list-item"><a href="/wiki/Speciale:RecentChangesLinked/SQL" rel="nofollow" title="Lista e ndryshimeve të faqeve që lidhen tek kjo faqe [k]" accesskey="k"><span>Ndryshime të ndërvarura</span></a></li><li id="t-upload" class="mw-list-item"><a href="//commons.wikimedia.org/wiki/Special:UploadWizard?uselang=sq" title="Ngarko skeda [u]" accesskey="u"><span>Ngarkoni materiale multimediale</span></a></li><li id="t-specialpages" class="mw-list-item"><a href="/wiki/Speciale:FaqetSpeciale" title="Lista e të gjitha faqeve speciale. [q]" accesskey="q"><span>Faqet e veçanta</span></a></li><li id="t-permalink" class="mw-list-item"><a href="/w/index.php?title=SQL&oldid=2615650" title="Lidhja e përhershme tek ky version i faqes"><span>Lidhja e përhershme</span></a></li><li id="t-info" class="mw-list-item"><a href="/w/index.php?title=SQL&action=info" title="Më shumë informacion për këtë faqe"><span>Informacioni i faqes</span></a></li><li id="t-cite" class="mw-list-item"><a href="/w/index.php?title=Speciale:Citim&page=SQL&id=2615650&wpFormIdentifier=titleform" title="Informacion mbi mënyrën e citimit të kësaj faqeje"><span>Cito artikullin</span></a></li><li id="t-urlshortener" class="mw-list-item"><a href="/w/index.php?title=Speciale:UrlShortener&url=https%3A%2F%2Fsq.wikipedia.org%2Fwiki%2FSQL"><span>Get shortened URL</span></a></li><li id="t-urlshortener-qrcode" class="mw-list-item"><a href="/w/index.php?title=Speciale:QrCode&url=https%3A%2F%2Fsq.wikipedia.org%2Fwiki%2FSQL"><span>Download QR code</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"> Shtyp/eksporto </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=Speciale:Libra&bookcmd=book_creator&referer=SQL"><span>Krijo një libër</span></a></li><li id="coll-download-as-rl" class="mw-list-item"><a href="/w/index.php?title=Speciale:DownloadAsPdf&page=SQL&action=show-download-screen"><span>Shkarkoje si PDF</span></a></li><li id="t-print" class="mw-list-item"><a href="/w/index.php?title=SQL&printable=yes" title="Version i shtypshëm i kësaj faqeje [p]" accesskey="p"><span>Version shtypi</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"> Në projekte të tjera </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li class="wb-otherproject-link wb-otherproject-commons mw-list-item"><a href="https://commons.wikimedia.org/wiki/Category:Structured_Query_Language" hreflang="en"><span>Wikimedia Commons</span></a></li><li id="t-wikibase" class="wb-otherproject-link wb-otherproject-wikibase-dataitem mw-list-item"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q47607" title="Lidhje për te objekt depoje të dhënash i lidhur [g]" accesskey="g"><span>Objekt Wikidata</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="Page tools"> <div id="vector-page-tools-pinned-container" class="vector-pinned-container"> </div> </nav> <nav class="vector-appearance-landmark" aria-label="Appearance"> <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">Appearance</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-appearance.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-appearance.unpin">fshihe</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">Nga Wikipedia, enciklopedia e lirë</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="sq" dir="ltr"><p><b>SQL</b> (<i>Structured Query Language</i>) është një gjuhë kompjuterike e projektuar për menaxhimin e të dhënave në <a href="/wiki/Relational_database_management_system" class="mw-redirect" title="Relational database management system">sistemet e menaxhimit të bazës së të dhënave relative</a> (<i>Relational data base management system</i>), dhe fillimisht e bazuar mbi <a href="/wiki/Algjebra" title="Algjebra">algjebrën relative</a>. Disa RDBMS që përdorin SQL janë Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Të gjitha dialektet e SQL-së përmbajnë disa bashkësi komandash qe mund te klasifikohen si nën-gjuhe programimi (sublanguage) : </p> <ul><li>Data Query Language (DQL) është bashkësia e komandave që përdoret për të kërkuar dhe afishuar të dhëna në një DB si psh komanda "Select".</li> <li>Data Definition Language (DDL) është bashkësia e komandave që përdoret për të përcaktuar skemën e objekteve të të dhënave dhe relatat midis tyre. Këto komanda krijojnë, modifikojnë dhe fshijnë objekte të bazës së të dhënave si DB, tabela, kollona, indekse etc. Shembuj te komandave DDL janë "Create Object", "Drop Object", "Alter Object".</li> <li>Data Manipulation Languange (DML) eshte bashkesia e komandave që mundëson manipulimin e të dhënave që ruhen brenda objekteve te databazës si krijimin, azhornimin, fshirjen e te dhenave. Shembuj të ketyre komandave janë Insert, Update, Delete.</li> <li>Data Control Language (DCL ) është bashkësia e komandave që përdoret për të autorizuar aksesin ne objekte, funksione dhe te dhena ne nje RDBMS. Shembuj te ketyre komandave jane GRANT, REVOKE etc.</li></ul> <meta property="mw:PageProp/toc" /> <div class="mw-heading mw-heading2"><h2 id="Historia">Historia</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=SQL&veaction=edit&section=1" title="Redakto pjesën: Historia" class="mw-editsection-visualeditor"><span>Redakto</span></a><span class="mw-editsection-divider"> | </span><a href="/w/index.php?title=SQL&action=edit&section=1" title="Edit section's source code: Historia"><span>Redakto nëpërmjet kodit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>SQL u zhvilluar ne <a href="/wiki/IBM" title="IBM">IBM</a> nga Donald D. Chamberlin dhe Raymond F. Boyce në fillim të viteve 1970. Ky version, i quajtur fillimisht SEQUEL, është projektuar për të manipuluar dhe ripërtërirë të dhënat e ruajtura në produkt origjinal të të dhënave relacionale të <a href="/wiki/IBM" title="IBM">IBM</a>, (System R). Gjatë viti 1970, një grup në IBM San Jose Research Laboratory zhvilloi Sistemin R të menaxhimit të sistemit të bazës së të dhënave relacionale. Donald D.Chamberlin dhe Raymond F.Boyce fillimisht e quajtën Structured English Query Language (SEQUEL ose SEQL). Emri SEQUEL u ndryshua më vonë në SQL sepse "SEQUEL" ishte një markë e kompanisë ajrore Hawker Siddeley e themeluar në <a href="/w/index.php?title=Mbret%C3%ABria_e_Bashkuar_e_Britanis%C3%AB_dhe_Irland%C3%ABs_s%C3%AB_Veriut&action=edit&redlink=1" class="new" title="Mbretëria e Bashkuar e Britanisë dhe Irlandës së Veriut (nuk është shkruar akoma)">Britaninë e Madhe</a>. </p> <div class="mw-heading mw-heading2"><h2 id="Queries">Queries</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=SQL&veaction=edit&section=2" title="Redakto pjesën: Queries" class="mw-editsection-visualeditor"><span>Redakto</span></a><span class="mw-editsection-divider"> | </span><a href="/w/index.php?title=SQL&action=edit&section=2" title="Edit section's source code: Queries"><span>Redakto nëpërmjet kodit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>Veprimi më i zakonshëm në SQL është query, i cili është paraqitet me komandën <a href="/wiki/Select_(SQL)" title="Select (SQL)">SELECT</a>. <a href="/wiki/Select_(SQL)" title="Select (SQL)">SELECT</a> rinxjerr të dhëna prej një ose më shumë tabelave ose shprehjeve. Standard deklaratat <a href="/wiki/Select_(SQL)" title="Select (SQL)">SELECT</a> nuk kanë efekte të vazhdueshme mbi bazën e të dhënave. Queries lejojnë përdoruesit për të përshkruar të dhënat e dëshiruara, duke ja lënë sistemit të menaxhimit të bazës së të dhënave (DBMS) përgjegjësinë për planifikimin. Një pyetje përfshin një listë të kolonave që përfshihen në rezultatin përfundimtar menjëherë pas fjalës <a href="/wiki/Select_(SQL)" title="Select (SQL)">SELECT</a>. Një yll ("*") mund të përdoret gjithashtu që të specifikojë nëse query duhet të paraqesë të gjitha kollonat e tabelave. <a href="/wiki/Select_(SQL)" title="Select (SQL)">SELECT</a> është deklarata më e ndërlikuar në SQL, me fjalë kyçe opsionale dhe dispozitat përfshirëse. </p> <div class="mw-heading mw-heading2"><h2 id="Sintaksa_SQL,_Elementet_e_gjuhës"><span id="Sintaksa_SQL.2C_Elementet_e_gjuh.C3.ABs"></span>Sintaksa SQL, Elementet e gjuhës</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=SQL&veaction=edit&section=3" title="Redakto pjesën: Sintaksa SQL, Elementet e gjuhës" class="mw-editsection-visualeditor"><span>Redakto</span></a><span class="mw-editsection-divider"> | </span><a href="/w/index.php?title=SQL&action=edit&section=3" title="Edit section's source code: Sintaksa SQL, Elementet e gjuhës"><span>Redakto nëpërmjet kodit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>Gjuha SQL përbëhet nga disa elemente që përfshijnë: </p> <ul><li>Klauzolat (Clauses) që janë pjesët përbërëse të Shprehjeve dhe të Queries</li> <li>Shprehjet (Expressions) që mund të prodhojnë vlera skalare ose tabela</li> <li>Kushtet (Predicates) që përcaktojnë konditat në bazë të të cilave do limitohet efekti i queries ose statement</li> <li>Pyetësorët (Queries) që marin të dhënat nga DB bazuar mbi disa kritere</li> <li>Deklaruesit (Statements) që kanë efekt permanent në sktrukturë dhe në të dhënat e DB, mund të kontrollojnë transaksionet, koneksionet, rrjedhën e programeve, të drejtat etj.</li></ul> <p>Elementet e gjuhës SQL, pjesë përbërëse të një statement jane ilustruar në fig. </p> <div class="thumb tright" style=""><div class="thumbinner" style="width:502px"><div class="thumbimage noresize" style="width:500px;"></div><div class="thumbcaption">Nje figure ku tregohen disa elemente sintaksore perberes te Gjuhes SQL qe i perkasin nje Statement</div></div></div> <div class="mw-heading mw-heading2"><h2 id="Gjuhë_të_tjera_të_ngjashme"><span id="Gjuh.C3.AB_t.C3.AB_tjera_t.C3.AB_ngjashme"></span>Gjuhë të tjera të ngjashme</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=SQL&veaction=edit&section=4" title="Redakto pjesën: Gjuhë të tjera të ngjashme" class="mw-editsection-visualeditor"><span>Redakto</span></a><span class="mw-editsection-divider"> | </span><a href="/w/index.php?title=SQL&action=edit&section=4" title="Edit section's source code: Gjuhë të tjera të ngjashme"><span>Redakto nëpërmjet kodit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>Bazuar ne Gjuhën standart SQL janë krijuar gjuhë te tjera për manaxhim bazash të dhënash te tipeve te ndryshme si shembujt ne tabele: </p> <table class="wikitable"> <tbody><tr> <th>DB </th> <th>Lloji SQL </th> <th>Emri i plotë </th></tr> <tr> <td>SQL Server </td> <td>T-SQL </td> <td>Transact-SQL </td></tr> <tr> <td>Oracle </td> <td>PL/SQL </td> <td>Procedural Language/SQL (based on <a href="/w/index.php?title=Ada_(programming_language)&action=edit&redlink=1" class="new" title="Ada (programming language) (nuk është shkruar akoma)">Ada</a>) </td></tr> <tr> <td>IBM DB2 </td> <td>SQL PL </td> <td>SQL Procedural Language (implements SQL/PSM) </td></tr> <tr> <td>PostgreSQL </td> <td>PL/pgSQL </td> <td>Procedural Language/PostgreSQL Structured Query Language (implements SQL/PSM) </td></tr> <tr> <td>IBM Informix </td> <td>SQL SPL </td> <td>Informix Dialect of SQL and Stored Procedural Language </td></tr> <tr> <td>IBM Netezza </td> <td>NZPLSQL </td> <td>(based on Postgres PL/pgSQL) </td></tr> <tr> <td><a href="/wiki/MySQL" title="MySQL">MySQL</a> </td> <td>SQL/PSM </td> <td>SQL/Persistent Stored Module (implements SQL/PSM) </td></tr> <tr> <td>SAP HANA </td> <td>SQLScript </td> <td>SQLScript </td></tr></tbody></table> <div class="mw-heading mw-heading2"><h2 id="Shih_edhe">Shih edhe</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=SQL&veaction=edit&section=5" title="Redakto pjesën: Shih edhe" class="mw-editsection-visualeditor"><span>Redakto</span></a><span class="mw-editsection-divider"> | </span><a href="/w/index.php?title=SQL&action=edit&section=5" title="Edit section's source code: Shih edhe"><span>Redakto nëpërmjet kodit</span></a><span class="mw-editsection-bracket">]</span></span></div> <ul><li><a href="/wiki/Baza_e_t%C3%AB_dh%C3%ABnave" title="Baza e të dhënave">Database</a></li></ul> <div class="mw-heading mw-heading2"><h2 id="Lidhje_të_jashtme"><span id="Lidhje_t.C3.AB_jashtme"></span>Lidhje të jashtme</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=SQL&veaction=edit&section=6" title="Redakto pjesën: Lidhje të jashtme" class="mw-editsection-visualeditor"><span>Redakto</span></a><span class="mw-editsection-divider"> | </span><a href="/w/index.php?title=SQL&action=edit&section=6" title="Edit section's source code: Lidhje të jashtme"><span>Redakto nëpërmjet kodit</span></a><span class="mw-editsection-bracket">]</span></span></div> <ul><li><a rel="nofollow" class="external text" href="http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95.html"><i>1995 SQL Reunion: People, Projects, and Politics</i>, by Paul McJones (ed.)</a>: transcript of a reunion meeting devoted to the personal history of relational databases and SQL.</li> <li><a rel="nofollow" class="external text" href="http://special.lib.umn.edu/findaid/xml/cbi00168.xml">American National Standards Institute. X3H2 Records, 1978-1995</a> <a href="/w/index.php?title=Charles_Babbage_Institute&action=edit&redlink=1" class="new" title="Charles Babbage Institute (nuk është shkruar akoma)">Charles Babbage Institute</a> Collection documents the H2 committee’s development of the NDL and SQL standards.</li> <li><a rel="nofollow" class="external text" href="https://web.archive.org/web/20121002222015/http://www.cbi.umn.edu/oh/display.phtml?id=317">Oral history interview with Donald D. Chamberlin</a> <a href="/w/index.php?title=Charles_Babbage_Institute&action=edit&redlink=1" class="new" title="Charles Babbage Institute (nuk është shkruar akoma)">Charles Babbage Institute</a> In this oral history Chamberlin recounts his early life, his education at <a href="/w/index.php?title=Harvey_Mudd_College&action=edit&redlink=1" class="new" title="Harvey Mudd College (nuk është shkruar akoma)">Harvey Mudd College</a> and <a href="/wiki/Stanford_University" class="mw-redirect" title="Stanford University">Stanford University</a>, and his work on relational database technology. Chamberlin was a member of the System R research team and, with <a href="/w/index.php?title=Raymond_F._Boyce&action=edit&redlink=1" class="new" title="Raymond F. Boyce (nuk është shkruar akoma)">Raymond F. Boyce</a>, developed the SQL database language. Chamberlin also briefly discusses his more recent research on XML query languages.</li> <li><a rel="nofollow" class="external text" href="http://troels.arvin.dk/db/rdbms/">Comparison of Different SQL Implementations</a> This comparison of various SQL implementations is intended to serve as a guide to those interested in porting SQL code between various RDBMS products, and includes comparisons between SQL:2008, PostgreSQL, DB2, MS SQL Server, MySQL, Oracle, and Informix.</li></ul> <div class="navbox-styles"><style data-mw-deduplicate="TemplateStyles:r2520769">.mw-parser-output .hlist dl,.mw-parser-output .hlist ol,.mw-parser-output .hlist ul{margin:0;padding:0}.mw-parser-output .hlist dd,.mw-parser-output .hlist dt,.mw-parser-output .hlist li{margin:0;display:inline}.mw-parser-output .hlist.inline,.mw-parser-output .hlist.inline dl,.mw-parser-output .hlist.inline ol,.mw-parser-output .hlist.inline ul,.mw-parser-output .hlist dl dl,.mw-parser-output .hlist dl ol,.mw-parser-output .hlist dl ul,.mw-parser-output .hlist ol dl,.mw-parser-output .hlist ol ol,.mw-parser-output .hlist ol ul,.mw-parser-output .hlist ul dl,.mw-parser-output .hlist ul ol,.mw-parser-output .hlist ul ul{display:inline}.mw-parser-output .hlist .mw-empty-li{display:none}.mw-parser-output .hlist dt::after{content:": "}.mw-parser-output .hlist dd::after,.mw-parser-output .hlist li::after{content:" · ";font-weight:bold}.mw-parser-output .hlist dd:last-child::after,.mw-parser-output .hlist dt:last-child::after,.mw-parser-output .hlist li:last-child::after{content:none}.mw-parser-output .hlist dd dd:first-child::before,.mw-parser-output .hlist dd dt:first-child::before,.mw-parser-output .hlist dd li:first-child::before,.mw-parser-output .hlist dt dd:first-child::before,.mw-parser-output .hlist dt dt:first-child::before,.mw-parser-output .hlist dt li:first-child::before,.mw-parser-output .hlist li dd:first-child::before,.mw-parser-output .hlist li dt:first-child::before,.mw-parser-output .hlist li li:first-child::before{content:" (";font-weight:normal}.mw-parser-output .hlist dd dd:last-child::after,.mw-parser-output .hlist dd dt:last-child::after,.mw-parser-output .hlist dd li:last-child::after,.mw-parser-output .hlist dt dd:last-child::after,.mw-parser-output .hlist dt dt:last-child::after,.mw-parser-output .hlist dt li:last-child::after,.mw-parser-output .hlist li dd:last-child::after,.mw-parser-output .hlist li dt:last-child::after,.mw-parser-output .hlist li li:last-child::after{content:")";font-weight:normal}.mw-parser-output .hlist ol{counter-reset:listitem}.mw-parser-output .hlist ol>li{counter-increment:listitem}.mw-parser-output .hlist ol>li::before{content:" "counter(listitem)"\a0 "}.mw-parser-output .hlist dd ol>li:first-child::before,.mw-parser-output .hlist dt ol>li:first-child::before,.mw-parser-output .hlist li ol>li:first-child::before{content:" ("counter(listitem)"\a0 "}</style><style data-mw-deduplicate="TemplateStyles:r2450697">.mw-parser-output .navbox{box-sizing:border-box;border:1px solid #a2a9b1;width:100%;clear:both;font-size:88%;text-align:center;padding:1px;margin:1em auto 0}.mw-parser-output .navbox .navbox{margin-top:0}.mw-parser-output .navbox+.navbox,.mw-parser-output .navbox+.navbox-styles+.navbox{margin-top:-1px}.mw-parser-output .navbox-inner,.mw-parser-output .navbox-subgroup{width:100%}.mw-parser-output .navbox-group,.mw-parser-output .navbox-title,.mw-parser-output .navbox-abovebelow{padding:0.25em 1em;line-height:1.5em;text-align:center}.mw-parser-output .navbox-group{white-space:nowrap;text-align:right}.mw-parser-output .navbox,.mw-parser-output .navbox-subgroup{background-color:#fdfdfd}.mw-parser-output .navbox-list{line-height:1.5em;border-color:#fdfdfd}.mw-parser-output .navbox-list-with-group{text-align:left;border-left-width:2px;border-left-style:solid}.mw-parser-output tr+tr>.navbox-abovebelow,.mw-parser-output tr+tr>.navbox-group,.mw-parser-output tr+tr>.navbox-image,.mw-parser-output tr+tr>.navbox-list{border-top:2px solid #fdfdfd}.mw-parser-output .navbox-title{background-color:#ccf}.mw-parser-output .navbox-abovebelow,.mw-parser-output .navbox-group,.mw-parser-output .navbox-subgroup .navbox-title{background-color:#ddf}.mw-parser-output .navbox-subgroup .navbox-group,.mw-parser-output .navbox-subgroup .navbox-abovebelow{background-color:#e6e6ff}.mw-parser-output .navbox-even{background-color:#f7f7f7}.mw-parser-output .navbox-odd{background-color:transparent}.mw-parser-output .navbox .hlist td dl,.mw-parser-output .navbox .hlist td ol,.mw-parser-output .navbox .hlist td ul,.mw-parser-output .navbox td.hlist dl,.mw-parser-output .navbox td.hlist ol,.mw-parser-output .navbox td.hlist ul{padding:0.125em 0}.mw-parser-output .navbox .navbar{display:block;font-size:100%}.mw-parser-output .navbox-title .navbar{float:left;text-align:left;margin-right:0.5em}</style></div><div role="navigation" class="navbox" aria-labelledby="SQL" style="padding:3px"><table class="nowraplinks mw-collapsible autocollapse navbox-inner" style="border-spacing:0;background:transparent;color:inherit"><tbody><tr><th scope="col" class="navbox-title" colspan="2"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r2520769"><style data-mw-deduplicate="TemplateStyles:r2479542">.mw-parser-output .navbar{display:inline;font-size:88%;font-weight:normal}.mw-parser-output .navbar-collapse{float:left;text-align:left}.mw-parser-output .navbar-boxtext{word-spacing:0}.mw-parser-output .navbar ul{display:inline-block;white-space:nowrap;line-height:inherit}.mw-parser-output .navbar-brackets::before{margin-right:-0.125em;content:"[ "}.mw-parser-output .navbar-brackets::after{margin-left:-0.125em;content:" ]"}.mw-parser-output .navbar li{word-spacing:-0.125em}.mw-parser-output .navbar a>span,.mw-parser-output .navbar a>abbr{text-decoration:inherit}.mw-parser-output .navbar-mini abbr{font-variant:small-caps;border-bottom:none;text-decoration:none;cursor:inherit}.mw-parser-output .navbar-ct-full{font-size:114%;margin:0 7em}.mw-parser-output .navbar-ct-mini{font-size:114%;margin:0 4em}</style><div class="navbar plainlinks hlist navbar-mini"><ul><li class="nv-view"><a href="/wiki/Stampa:SQL" title="Stampa:SQL"><abbr title="View this template" style=";;background:none transparent;color:inherit;border:none;box-shadow:none;padding:0;">v</abbr></a></li><li class="nv-talk"><a href="/w/index.php?title=Stampa_diskutim:SQL&action=edit&redlink=1" class="new" title="Stampa diskutim:SQL (nuk është shkruar akoma)"><abbr title="Discuss this template" style=";;background:none transparent;color:inherit;border:none;box-shadow:none;padding:0;">t</abbr></a></li><li class="nv-edit"><a class="external text" href="https://sq.wikipedia.org/w/index.php?title=Stampa:SQL&action=edit"><abbr title="Edit this template" style=";;background:none transparent;color:inherit;border:none;box-shadow:none;padding:0;">e</abbr></a></li></ul></div><div id="SQL" style="font-size:114%;margin:0 4em"><a class="mw-selflink selflink">SQL</a></div></th></tr><tr><th scope="row" class="navbox-group" style="width:1%">Versione</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">SQL-86  <b>·</b>  SQL-89  <b>·</b>  <a href="/w/index.php?title=SQL-92&action=edit&redlink=1" class="new" title="SQL-92 (nuk është shkruar akoma)">SQL-92</a>  <b>·</b>  <a href="/w/index.php?title=SQL:1999&action=edit&redlink=1" class="new" title="SQL:1999 (nuk është shkruar akoma)">SQL:1999</a>  <b>·</b>  <a href="/w/index.php?title=SQL:2003&action=edit&redlink=1" class="new" title="SQL:2003 (nuk është shkruar akoma)">SQL:2003</a>  <b>·</b>  <a href="/w/index.php?title=SQL:2008&action=edit&redlink=1" class="new" title="SQL:2008 (nuk është shkruar akoma)">SQL:2008</a></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Fjalë kyçe</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"><a href="/wiki/Delete_(SQL)" title="Delete (SQL)">Delete</a>  <b>·</b>  <a href="/wiki/From_(SQL)" title="From (SQL)">From</a>  <b>·</b>  <a href="/wiki/Having_(SQL)" title="Having (SQL)">Having</a>  <b>·</b>  <a href="/wiki/Insert_(SQL)" title="Insert (SQL)">Insert</a>  <b>·</b>  <a href="/w/index.php?title=Join_(SQL)&action=edit&redlink=1" class="new" title="Join (SQL) (nuk është shkruar akoma)">Join</a>  <b>·</b>  <a href="/w/index.php?title=Merge_(SQL)&action=edit&redlink=1" class="new" title="Merge (SQL) (nuk është shkruar akoma)">Merge</a>  <b>·</b>  <a href="/w/index.php?title=Null_(SQL)&action=edit&redlink=1" class="new" title="Null (SQL) (nuk është shkruar akoma)">Null</a>  <b>·</b>  <a href="/wiki/Order_by_(SQL)" title="Order by (SQL)">Order by</a>  <b>·</b>  <a href="/w/index.php?title=Prepare_(SQL)&action=edit&redlink=1" class="new" title="Prepare (SQL) (nuk është shkruar akoma)">Prepare</a>  <b>·</b>  <a href="/wiki/Select_(SQL)" title="Select (SQL)">Select</a>  <b>·</b>  <a href="/w/index.php?title=Truncate_(SQL)&action=edit&redlink=1" class="new" title="Truncate (SQL) (nuk është shkruar akoma)">Truncate</a>  <b>·</b>  <a href="/w/index.php?title=Set_operations_(SQL)&action=edit&redlink=1" class="new" title="Set operations (SQL) (nuk është shkruar akoma)">Union</a>  <b>·</b>  <a href="/wiki/Update_(SQL)" title="Update (SQL)">Update</a>  <b>·</b>  <a href="/wiki/Where_(SQL)" title="Where (SQL)">Where</a></div></td></tr></tbody></table></div> <div class="navbox-styles"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r2520769"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r2450697"></div><div role="navigation" class="navbox" aria-labelledby="Sistemi_i_menaxhimit_të_Database" style="padding:3px"><table class="nowraplinks mw-collapsible autocollapse navbox-inner" style="border-spacing:0;background:transparent;color:inherit"><tbody><tr><th scope="col" class="navbox-title" colspan="2"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r2520769"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r2479542"><div class="navbar plainlinks hlist navbar-mini"><ul><li class="nv-view"><a href="/wiki/Stampa:Database" title="Stampa:Database"><abbr title="View this template" style=";;background:none transparent;color:inherit;border:none;box-shadow:none;padding:0;">v</abbr></a></li><li class="nv-talk"><a href="/w/index.php?title=Stampa_diskutim:Database&action=edit&redlink=1" class="new" title="Stampa diskutim:Database (nuk është shkruar akoma)"><abbr title="Discuss this template" style=";;background:none transparent;color:inherit;border:none;box-shadow:none;padding:0;">t</abbr></a></li><li class="nv-edit"><a class="external text" href="https://sq.wikipedia.org/w/index.php?title=Stampa:Database&action=edit"><abbr title="Edit this template" style=";;background:none transparent;color:inherit;border:none;box-shadow:none;padding:0;">e</abbr></a></li></ul></div><div id="Sistemi_i_menaxhimit_të_Database" style="font-size:114%;margin:0 4em"><a href="/wiki/Database_managment_system" class="mw-redirect" title="Database managment system">Sistemi i menaxhimit të Database</a></div></th></tr><tr><td class="navbox-abovebelow" colspan="2"><div id="Modelet_e_Database_·_Rujatja_e_strukturave_të_Database_·_Sistemi_i_menaxhimit_të_shpërndarjes_të_Database_·_Algjebra_Relative_·_Njehsimi_Relativ_·_Baza_e_të_dhënave_Relative_·_Sistemi_i_menaxhimit_të_bazës_së_të_dhënave_relative_·_Modeli_relativ"><a href="/wiki/Database_models" class="mw-redirect" title="Database models">Modelet e Database</a> <b>·</b>  <a href="/w/index.php?title=Database_storage_structures&action=edit&redlink=1" class="new" title="Database storage structures (nuk është shkruar akoma)">Rujatja e strukturave të Database</a> <b>·</b>  <a href="/w/index.php?title=Distributed_database_management_system&action=edit&redlink=1" class="new" title="Distributed database management system (nuk është shkruar akoma)">Sistemi i menaxhimit të shpërndarjes të Database</a> <b>·</b> <a href="/w/index.php?title=Algjebra_Relative&action=edit&redlink=1" class="new" title="Algjebra Relative (nuk është shkruar akoma)">Algjebra Relative</a> <b>·</b>  <a href="/w/index.php?title=Njehsimi_Relativ&action=edit&redlink=1" class="new" title="Njehsimi Relativ (nuk është shkruar akoma)">Njehsimi Relativ</a> <b>·</b>  <a href="/w/index.php?title=Relational_database&action=edit&redlink=1" class="new" title="Relational database (nuk është shkruar akoma)">Baza e të dhënave Relative</a> <b>·</b>  <a href="/wiki/Relational_database_management_system" class="mw-redirect" title="Relational database management system">Sistemi i menaxhimit të bazës së të dhënave relative</a> <b>·</b>  <a href="/w/index.php?title=Modeli_relativ&action=edit&redlink=1" class="new" title="Modeli relativ (nuk është shkruar akoma)">Modeli relativ</a></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Koncepte</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"><a href="/wiki/Database" class="mw-redirect" title="Database">Database</a> <b>·</b>  <a href="/w/index.php?title=ACID&action=edit&redlink=1" class="new" title="ACID (nuk është shkruar akoma)">ACID</a> <b>·</b>  <a href="/w/index.php?title=Create,_read,_update_and_delete&action=edit&redlink=1" class="new" title="Create, read, update and delete (nuk është shkruar akoma)">CRUD</a> <b>·</b>  <a href="/w/index.php?title=Null_(SQL)&action=edit&redlink=1" class="new" title="Null (SQL) (nuk është shkruar akoma)">Null</a> <b>·</b>  <a href="/w/index.php?title=Candidate_key&action=edit&redlink=1" class="new" title="Candidate key (nuk është shkruar akoma)">Candidate key</a> <b>·</b>  <a href="/w/index.php?title=Foreign_key&action=edit&redlink=1" class="new" title="Foreign key (nuk është shkruar akoma)">Foreign key</a> <b>·</b>  <a href="/w/index.php?title=Primary_key&action=edit&redlink=1" class="new" title="Primary key (nuk është shkruar akoma)">Primary key</a> <b>·</b>  <a href="/w/index.php?title=Superkey&action=edit&redlink=1" class="new" title="Superkey (nuk është shkruar akoma)">Superkey</a> <b>·</b>  <a href="/w/index.php?title=Surrogate_key&action=edit&redlink=1" class="new" title="Surrogate key (nuk është shkruar akoma)">Surrogate key</a> <b>·</b>  <a href="/w/index.php?title=Armstrong%27s_axioms&action=edit&redlink=1" class="new" title="Armstrong's axioms (nuk është shkruar akoma)">Armstrong's axioms</a></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Objekte</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"><a href="/w/index.php?title=Relation_(database)&action=edit&redlink=1" class="new" title="Relation (database) (nuk është shkruar akoma)">Relation</a> (<a href="/w/index.php?title=Table_(database)&action=edit&redlink=1" class="new" title="Table (database) (nuk është shkruar akoma)">Table</a>) <b>·</b>  <a href="/w/index.php?title=View_(database)&action=edit&redlink=1" class="new" title="View (database) (nuk është shkruar akoma)">View</a> <b>·</b>  <a href="/w/index.php?title=Database_transaction&action=edit&redlink=1" class="new" title="Database transaction (nuk është shkruar akoma)">Transaction</a> <b>·</b>  <a href="/w/index.php?title=Transaction_log&action=edit&redlink=1" class="new" title="Transaction log (nuk është shkruar akoma)">Log</a> <b>·</b>  <a href="/w/index.php?title=Database_trigger&action=edit&redlink=1" class="new" title="Database trigger (nuk është shkruar akoma)">Trigger</a> <b>·</b>  <a href="/w/index.php?title=Index_(database)&action=edit&redlink=1" class="new" title="Index (database) (nuk është shkruar akoma)">Index</a> <b>·</b>  <a href="/w/index.php?title=Stored_procedure&action=edit&redlink=1" class="new" title="Stored procedure (nuk është shkruar akoma)">Stored procedure</a> <b>·</b>  <a href="/w/index.php?title=Cursor_(databases)&action=edit&redlink=1" class="new" title="Cursor (databases) (nuk është shkruar akoma)">Cursor</a> <b>·</b>  <a href="/w/index.php?title=Partition_(database)&action=edit&redlink=1" class="new" title="Partition (database) (nuk është shkruar akoma)">Partition</a></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%"><a class="mw-selflink selflink">SQL</a></th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"><a href="/wiki/Select_(SQL)" title="Select (SQL)">Select</a> <b>·</b>  <a href="/wiki/Insert_(SQL)" title="Insert (SQL)">Insert</a> <b>·</b>  <a href="/wiki/Update_(SQL)" title="Update (SQL)">Update</a> <b>·</b>  <a href="/w/index.php?title=Merge_(SQL)&action=edit&redlink=1" class="new" title="Merge (SQL) (nuk është shkruar akoma)">Merge</a> <b>·</b>  <a href="/wiki/Delete_(SQL)" title="Delete (SQL)">Delete</a> <b>·</b>  <a href="/wiki/From_(SQL)" title="From (SQL)">From</a> <b>·</b>  <a href="/w/index.php?title=Join_(SQL)&action=edit&redlink=1" class="new" title="Join (SQL) (nuk është shkruar akoma)">Join</a> <b>·</b>  <a href="/w/index.php?title=Union_(SQL)&action=edit&redlink=1" class="new" title="Union (SQL) (nuk është shkruar akoma)">Union</a> <b>·</b>  <a href="/w/index.php?title=Create_(SQL)&action=edit&redlink=1" class="new" title="Create (SQL) (nuk është shkruar akoma)">Create</a> <b>·</b>  <a href="/w/index.php?title=Data_Definition_Language&action=edit&redlink=1" class="new" title="Data Definition Language (nuk është shkruar akoma)">Drop</a> <b>·</b>  <a href="/w/index.php?title=Database_transaction&action=edit&redlink=1" class="new" title="Database transaction (nuk është shkruar akoma)">Start Transaction</a> <b>·</b>  <a href="/w/index.php?title=Commit_(data_management)&action=edit&redlink=1" class="new" title="Commit (data management) (nuk është shkruar akoma)">Commit</a> <b>·</b>  <a href="/w/index.php?title=Rollback_(SQL)&action=edit&redlink=1" class="new" title="Rollback (SQL) (nuk është shkruar akoma)">Rollback</a> <b>·</b>  <a href="/w/index.php?title=Truncate_(SQL)&action=edit&redlink=1" class="new" title="Truncate (SQL) (nuk është shkruar akoma)">Truncate</a> <b>·</b>  <a href="/w/index.php?title=Alter_(SQL)&action=edit&redlink=1" class="new" title="Alter (SQL) (nuk është shkruar akoma)">Alter</a> <b>·</b>  <a href="/wiki/Where_(SQL)" title="Where (SQL)">Where</a></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Elemete</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em"><a href="/w/index.php?title=Concurrency_control&action=edit&redlink=1" class="new" title="Concurrency control (nuk është shkruar akoma)">Concurrency control</a> <b>·</b>  <a href="/w/index.php?title=Data_dictionary&action=edit&redlink=1" class="new" title="Data dictionary (nuk është shkruar akoma)">Data dictionary</a> <b>·</b>  <a href="/w/index.php?title=Java_Database_Connectivity&action=edit&redlink=1" class="new" title="Java Database Connectivity (nuk është shkruar akoma)">JDBC</a> <b>·</b>  <a href="/w/index.php?title=Open_Database_Connectivity&action=edit&redlink=1" class="new" title="Open Database Connectivity (nuk është shkruar akoma)">ODBC</a> <b>·</b>  <a href="/w/index.php?title=Query_language&action=edit&redlink=1" class="new" title="Query language (nuk është shkruar akoma)">Query language</a> <b>·</b>  <a href="/w/index.php?title=Query_optimizer&action=edit&redlink=1" class="new" title="Query optimizer (nuk është shkruar akoma)">Query optimizer</a> <b>·</b>  <a href="/w/index.php?title=Query_plan&action=edit&redlink=1" class="new" title="Query plan (nuk është shkruar akoma)">Query plan</a></div></td></tr></tbody></table></div></div><noscript><img src="https://login.wikimedia.org/wiki/Special:CentralAutoLogin/start?type=1x1" alt="" width="1" height="1" style="border: none; position: absolute;"></noscript> <div class="printfooter" data-nosnippet="">Marrë nga "<a dir="ltr" href="https://sq.wikipedia.org/w/index.php?title=SQL&oldid=2615650">https://sq.wikipedia.org/w/index.php?title=SQL&oldid=2615650</a>"</div></div> <div id="catlinks" class="catlinks" data-mw="interface"><div id="mw-normal-catlinks" class="mw-normal-catlinks"><a href="/wiki/Speciale:Kategorit%C3%AB" title="Speciale:Kategoritë">Kategoritë</a>: <ul><li><a href="/wiki/Kategoria:P%C3%ABrpunim_i_t%C3%AB_dh%C3%ABnave" title="Kategoria:Përpunim i të dhënave">Përpunim i të dhënave</a></li><li><a href="/wiki/Kategoria:Database" title="Kategoria:Database">Database</a></li><li><a href="/wiki/Kategoria:SQL" title="Kategoria:SQL">SQL</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"> Kjo faqe është redaktuar për herë te fundit më 16 nëntor 2023, në orën 13:53.</li> <li id="footer-info-copyright">Të gjitha materialet që gjenden në këtë faqë janë të mbrojtura nga <a rel="nofollow" class="external text" href="//creativecommons.org/licenses/by-sa/4.0/">Creative Commons Attribution/Share-Alike License</a>;. Shiko <a class="external text" href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Terms_of_Use">Terms of Use</a> për më shumë informacione.</li> </ul> <ul id="footer-places"> <li id="footer-places-privacy"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Rreth të dhënave vetjake</a></li> <li id="footer-places-about"><a href="/wiki/Wikipedia:Rreth">Rreth Wikipedia-s</a></li> <li id="footer-places-disclaimers"><a href="/wiki/Wikipedia:Shfaj%C3%ABsimet_e_p%C3%ABrgjithshme">Shfajësimet</a></li> <li id="footer-places-wm-codeofconduct"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Universal_Code_of_Conduct">Code of Conduct</a></li> <li id="footer-places-developers"><a href="https://developer.wikimedia.org">Programuesit</a></li> <li id="footer-places-statslink"><a href="https://stats.wikimedia.org/#/sq.wikipedia.org">Statistikat</a></li> <li id="footer-places-cookiestatement"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Cookie_statement">Deklarata e cookies</a></li> <li id="footer-places-mobileview"><a href="//sq.m.wikipedia.org/w/index.php?title=SQL&mobileaction=toggle_view_mobile" class="noprint stopMobileRedirectToggle">Për celular</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-57488d5c7d-zxqdr","wgBackendResponseTime":390,"wgPageParseReport":{"limitreport":{"cputime":"0.117","walltime":"0.154","ppvisitednodes":{"value":290,"limit":1000000},"postexpandincludesize":{"value":25126,"limit":2097152},"templateargumentsize":{"value":208,"limit":2097152},"expansiondepth":{"value":7,"limit":100},"expensivefunctioncount":{"value":0,"limit":500},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":15562,"limit":5000000},"entityaccesscount":{"value":0,"limit":400},"timingprofile":["100.00% 124.821 1 -total"," 83.72% 104.506 1 Stampa:SQL"," 79.87% 99.697 2 Stampa:Navbox"," 11.99% 14.962 1 Stampa:Database"," 4.09% 5.110 1 Stampa:Image_frame"," 2.84% 3.542 63 Stampa:·"]},"scribunto":{"limitreport-timeusage":{"value":"0.068","limit":"10.000"},"limitreport-memusage":{"value":911344,"limit":52428800}},"cachereport":{"origin":"mw-web.eqiad.main-59856bd7d8-sxfh9","timestamp":"20241119190120","ttl":2592000,"transientcontent":false}}});});</script> <script type="application/ld+json">{"@context":"https:\/\/schema.org","@type":"Article","name":"SQL","url":"https:\/\/sq.wikipedia.org\/wiki\/SQL","sameAs":"http:\/\/www.wikidata.org\/entity\/Q47607","mainEntity":"http:\/\/www.wikidata.org\/entity\/Q47607","author":{"@type":"Organization","name":"Contributors to Wikimedia projects"},"publisher":{"@type":"Organization","name":"Wikimedia Foundation, Inc.","logo":{"@type":"ImageObject","url":"https:\/\/www.wikimedia.org\/static\/images\/wmf-hor-googpub.png"}},"datePublished":"2010-01-27T13:46:59Z"}</script> </body> </html>