{"id":1028,"date":"2022-11-08T05:59:00","date_gmt":"2022-11-08T04:59:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1028"},"modified":"2022-11-23T10:05:00","modified_gmt":"2022-11-23T09:05:00","slug":"requetes-select-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/","title":{"rendered":"Requ\u00eates SELECT SQL Server pour s\u00e9lectionner et filtrer"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Exemples de requ\u00eates avec la fonction SELECT SQL Server.<\/em><\/strong><\/h4>\n\n\n\n<p>Tutoriels pour apprendre \u00e0 s\u00e9lectionner les donn\u00e9es depuis une table avec des exemples de requ\u00eates SELECT SQL Server. C&rsquo;est la requ\u00eate de base car le langage SQL, pour <a href=\"https:\/\/www.techopedia.com\/definition\/1245\/structured-query-language-sql\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Structured Query Language<\/a>, est fait avant tout pour interroger et afficher des donn\u00e9es \u00e0 partir d&rsquo;une table. La requ\u00eate est du type LID pour Langage d&rsquo;Interrogation de Donn\u00e9es.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#1-exemples-de-requetes-select-sql-server-simples\" >1. Exemples de requ\u00eates SELECT SQL Server simples<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#11-creer-la-table-utilisee-dans-les-requetes\" >1.1 Cr\u00e9er la table utilis\u00e9e dans les requ\u00eates<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#12-inserer-des-donnees-dans-la-table-des-ventes\" >1.2 Ins\u00e9rer des donn\u00e9es dans la table des ventes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#13-requete-de-selection-avec-une-seule-colonne\" >1.3 Requ\u00eate de s\u00e9lection avec une seule colonne<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#14-requete-select-from-pour-afficher-toutes-les-colonnes\" >1.4 Requ\u00eate SELECT * FROM pour afficher toutes les colonnes<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#2-requete-select-sql-server-avec-la-clause-where\" >2. Requ\u00eate SELECT SQL Server avec la clause WHERE<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#21-selection-avec-un-filtre-sur-la-colonne-mois\" >2.1 S\u00e9lection avec un filtre sur la colonne Mois<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#22-requete-de-selection-avec-la-clause-where-et-un-operateur-or\" >2.2 Requ\u00eate de s\u00e9lection avec la clause WHERE et un op\u00e9rateur OR<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#23-requete-ms-sql-de-selection-avec-loperateur-in\" >2.3 Requ\u00eate MS SQL de s\u00e9lection avec l&rsquo;op\u00e9rateur IN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#24-requete-sql-avec-clause-where-et-operateur-different-de\" >2.4 Requ\u00eate SQL avec clause WHERE et op\u00e9rateur diff\u00e9rent de<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-exemples-de-requetes-select-sql-server-simples\"><span class=\"ez-toc-section\" id=\"1-exemples-de-requetes-select-sql-server-simples\"><\/span>1. Exemples de requ\u00eates SELECT SQL Server simples<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En effet, la commande SELECT permet d&rsquo;afficher et de lire les donn\u00e9es. La requ\u00eate SELECT est donc la plus utilis\u00e9e et indispensable en SQL.&nbsp;De plus, elle permet d&rsquo;afficher une seule colonne ou toutes les colonnes dans une seule requ\u00eate SELECT. C&rsquo;est \u00e0 dire qu&rsquo;il est possible de filtrer de deux mani\u00e8res diff\u00e9rentes : <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Filtre horizontal : S\u00e9lectionner une ou plusieurs colonnes<\/li>\n\n\n\n<li>Filtre vertical : filtrer les donn\u00e9es avec des conditions et la clause WHERE par exemple<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"11-creer-la-table-utilisee-dans-les-requetes\"><\/span>1.1 Cr\u00e9er la table utilis\u00e9e dans les requ\u00eates<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Premi\u00e8rement, avant d&rsquo;ex\u00e9cuter les commandes de s\u00e9lection, cr\u00e9er au pr\u00e9alable <a href=\"https:\/\/expert-only.com\/t-sql\/creer-table-sql-server\/\">la table d&rsquo;exemple<\/a> des ventes par mois avec ce script.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Tester si la table existe dans la base\n-- Pour la supprimer\nIF EXISTS( \n\tSELECT  1 FROM sys.objects\n\tWHERE   object_id = object_id(N'[dbo].[VENTES]') \n\t\tAND type in (N'U')  \n)\n     DROP TABLE [dbo].[VENTES];\nGO\n \n-- Cr\u00e9er la table VENTES pour les exemples T-SQL\nCREATE  table [dbo].[VENTES] \n(\n    [Mois]    NVARCHAR(20),\n    [Montant] NUMERIC(5)\n)\nGO\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"12-inserer-des-donnees-dans-la-table-des-ventes\"><\/span>1.2 Ins\u00e9rer des donn\u00e9es dans la table des ventes<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Deuxi\u00e8me \u00e9tape, ins\u00e9rer des lignes avec les montants des ventes mensuelles pour les 12 mois de l&rsquo;ann\u00e9e. <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Insertion des donn\u00e9es de Ventes pour notre exemple\nINSERT INTO dbo.VENTES (Mois, Montant) VALUES (N'Janvier', 1000);\nINSERT INTO dbo.VENTES (Mois, Montant) VALUES (N'F\u00e9vrier', 2000);\nINSERT INTO dbo.VENTES (Mois, Montant) VALUES (N'Mars', 3000);\nINSERT INTO dbo.VENTES (Mois, Montant) VALUES (N'Avril', 1000);\nINSERT INTO dbo.VENTES (Mois, Montant) VALUES (N'Mai', 2000);\nINSERT INTO dbo.VENTES (Mois, Montant) VALUES (N'Juin', 3000);\nINSERT INTO dbo.VENTES (Mois, Montant) VALUES (N'Juillet', 1000);\nINSERT INTO dbo.VENTES (Mois, Montant) VALUES (N'Aout', 2000);\nINSERT INTO dbo.VENTES (Mois, Montant) VALUES (N'Septembre', 3000);\nINSERT INTO dbo.VENTES (Mois, Montant) VALUES (N'Octobre', 1000);\nINSERT INTO dbo.VENTES (Mois, Montant) VALUES (N'Novembre', 2000);\nINSERT INTO dbo.VENTES (Mois, Montant) VALUES (N'D\u00e9cembre', 3000);\nGO\n\n-- S\u00e9lection des r\u00e9sultats pour contr\u00f4le\nSELECT * \nFROM   dbo.VENTES;\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-3-requete-de-selection-avec-une-seule-colonne\"><span class=\"ez-toc-section\" id=\"13-requete-de-selection-avec-une-seule-colonne\"><\/span>1.3 Requ\u00eate de s\u00e9lection avec une seule colonne<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Dans l&rsquo;exemple ci-dessous, s\u00e9lectionner uniquement la colonne MOIS depuis la table des ventes.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\tMOIS\nFROM\tdbo.VENTES;\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"461\" height=\"231\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SELECT-SQL-Server-Simple.png\" alt=\"Requ\u00eates SELECT SQL Server, pour afficher le mois depuis la table des ventes\" class=\"wp-image-1031\" title=\"requ\u00eate SQL Select pour afficher le mois depuis la table des ventes\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SELECT-SQL-Server-Simple.png 461w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SELECT-SQL-Server-Simple-300x150.png 300w\" sizes=\"auto, (max-width: 461px) 100vw, 461px\" \/><figcaption class=\"wp-element-caption\">Requ\u00eates SELECT SQL Server<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-4-requete-select-from-pour-afficher-toutes-les-colonnes\"><span class=\"ez-toc-section\" id=\"14-requete-select-from-pour-afficher-toutes-les-colonnes\"><\/span>1.4 Requ\u00eate SELECT * FROM pour afficher toutes les colonnes<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>D&rsquo;autre part, dans cet exemple, la requ\u00eate affiche toutes les colonnes de la table, soit MOIS et MONTANT.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\t*\nFROM\tdbo.VENTES;\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"499\" height=\"230\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SELECT-SQL-Server-Simple-toutes-colonnes.png\" alt=\"Requ\u00eates SELECT SQL Server avec toutes les colonnes\" class=\"wp-image-1032\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SELECT-SQL-Server-Simple-toutes-colonnes.png 499w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SELECT-SQL-Server-Simple-toutes-colonnes-300x138.png 300w\" sizes=\"auto, (max-width: 499px) 100vw, 499px\" \/><figcaption class=\"wp-element-caption\">Requ\u00eates SELECT SQL Server avec toutes les colonnes<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-requete-select-sql-server-avec-la-clause-where\"><span class=\"ez-toc-section\" id=\"2-requete-select-sql-server-avec-la-clause-where\"><\/span>2. Requ\u00eate SELECT SQL Server avec la clause WHERE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La clause WHERE permet de filtrer les donn\u00e9es en ajoutant une ou plusieurs conditions et donc de n&rsquo;afficher que les lignes de la table qui correspondent \u00e0 la condition. La clause WHERE en SQL est certainement la clause LMD la plus utilis\u00e9e dans le domaine des bases de donn\u00e9es. LMD signifie Langage de Manipulation des Donn\u00e9es, soit le langage utilis\u00e9 pour la manipulation des donn\u00e9es et non les objets eux-m\u00eames. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"21-selection-avec-un-filtre-sur-la-colonne-mois\"><\/span>2.1 S\u00e9lection avec un filtre sur la colonne Mois<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Pour afficher le nom de mois et le montant de la ligne dont le nom du mois est exactement Janvier.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n\tMois,\n\tMontant\nFROM\tdbo.VENTES\nWHERE \tMois = 'Janvier';\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-2-2-requete-de-selection-avec-la-clause-where-et-un-operateur-or\"><span class=\"ez-toc-section\" id=\"22-requete-de-selection-avec-la-clause-where-et-un-operateur-or\"><\/span>2.2 Requ\u00eate de s\u00e9lection avec la clause WHERE et un op\u00e9rateur OR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>L&rsquo;op\u00e9rateur OR est un OU logique. Pour afficher les mois dont le nom est <em>Janvier<\/em> ou <em>F\u00e9vrier<\/em>. Noter que la clause OR permet de mixer des conditions sur diff\u00e9rentes colonnes et ainsi de filtrer pr\u00e9cis\u00e9ment les donn\u00e9es de la table. Que ce soit d&rsquo;une mani\u00e8re inclusive ou plus exclusive.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n  Mois,\n  Montant\nFROM  dbo.VENTES\nWHERE Mois = 'Janvier';\n  OR  Mois = 'F\u00e9vrier'\n  OR  Montant > 1000;\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"23-requete-ms-sql-de-selection-avec-loperateur-in\"><\/span>2.3 Requ\u00eate MS SQL de s\u00e9lection avec l&rsquo;op\u00e9rateur IN<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>De la m\u00eame fa\u00e7on pour afficher toutes les lignes de la table dont le mois est \u00e9gal \u00e0 une valeur bien pr\u00e9cise, utiliser l&rsquo;op\u00e9rateur <a href=\"https:\/\/sql.sh\/cours\/where\/in\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">SQL IN<\/a>. Cette requ\u00eate affichera par exemple les trois premiers mois de l&rsquo;ann\u00e9e:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Janvier<\/li>\n\n\n\n<li>F\u00e9vrier<\/li>\n\n\n\n<li>Mars<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n  Mois,\n  Montant\nFROM  dbo.VENTES\nWHERE Mois IN ('Janvier', 'F\u00e9vrier', 'Mars');\n\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-2-4-requete-sql-avec-clause-where-et-operateur-different-de\"><span class=\"ez-toc-section\" id=\"24-requete-sql-avec-clause-where-et-operateur-different-de\"><\/span>2.4 Requ\u00eate SQL avec clause WHERE et op\u00e9rateur diff\u00e9rent de<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Pour afficher une liste de tous les clients dont le nom est diff\u00e9rent de MAMMADOU. Cet exemple de requ\u00eate utilise le mot clef \u00e9toile : *. Le mot clef SLECT * affiche toutes les colonnes de la table. Le mot clef <a href=\"https:\/\/fr.wikipedia.org\/wiki\/Select_(SQL)\" target=\"_blank\" rel=\"noreferrer noopener\">SELECT<\/a> \u00e9toile, aussi appel\u00e9 <strong><em>SELECT STAR<\/em><\/strong> en Anglais,  ou permet d&rsquo;afficher toutes les colonnes sans les nommer explicitement. <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT \t*\nFROM\tdbo.VENTES\nWHERE\tMois &lt;> 'D\u00e9cembre';\n<\/pre>\n\n\n\n<p>Noter qu&rsquo;une bonne pratique SQL Server est de ne pas utiliser le mot clef SELECT *. Surtout dans les programmes ou scripts o\u00f9 les colonnes \u00e9voluent. En effet, si un nom de colonne change alors le programme ne reconnait plus la colonne. Sauf si le programme g\u00e8re les noms de colonnes de mani\u00e8re dynamique.<\/p>\n\n\n\n<p>Il est donc recommand\u00e9 de nommer explicitement toutes les colonnes pour contr\u00f4ler :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Le nombre exact de colonnes utilis\u00e9es<\/li>\n\n\n\n<li>Le nom des colonnes<\/li>\n\n\n\n<li>Et aussi l&rsquo;ordre des colonnes<\/li>\n<\/ul>\n\n\n\n<p>Enfin, cet article explique et d\u00e9compose des requ\u00eates Select SQL Server, pour effectuer des s\u00e9lections de donn\u00e9es basiques. Pour aller plus loin et apprendre la gestion des tables comme la cr\u00e9ation d&rsquo;une table ou encore <a href=\"https:\/\/expert-only.com\/t-sql\/modifier-une-colonne-sql-server\/\">la modification d&rsquo;une colonne avec la commande Alter Column<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"JzSV8wqvmU\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-colonne-sql-server\/\">Modifier une colonne SQL Server avec un script<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Modifier une colonne SQL Server avec un script\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-colonne-sql-server\/embed\/#?secret=WR6ZR2vOTz#?secret=JzSV8wqvmU\" data-secret=\"JzSV8wqvmU\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Exemples de requ\u00eates avec la fonction SELECT SQL Server. Tutoriels pour apprendre \u00e0 s\u00e9lectionner les donn\u00e9es depuis une table avec des exemples de requ\u00eates SELECT SQL Server. C&rsquo;est la requ\u00eate de base car le langage SQL, pour Structured Query <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/\" title=\"Requ\u00eates SELECT SQL Server pour s\u00e9lectionner et filtrer\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10607,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-1028","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Requ\u00eates SELECT SQL Server pour s\u00e9lectionner et filtrer<\/title>\n<meta name=\"description\" content=\"Exemples de requ\u00eates SELECT SQL Server simples pour afficher les donn\u00e9es d&#039;une table avec des filtres et des op\u00e9rateurs de s\u00e9lection.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Requ\u00eates SELECT SQL Server pour s\u00e9lectionner et filtrer\" \/>\n<meta property=\"og:description\" content=\"Exemples de requ\u00eates SELECT SQL Server simples pour afficher les donn\u00e9es d&#039;une table avec des filtres et des op\u00e9rateurs de s\u00e9lection.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-08T04:59:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-23T09:05:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Requ\u00eates SELECT SQL Server pour s\u00e9lectionner et filtrer\",\"datePublished\":\"2022-11-08T04:59:00+00:00\",\"dateModified\":\"2022-11-23T09:05:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/\"},\"wordCount\":771,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/\",\"name\":\"Requ\u00eates SELECT SQL Server pour s\u00e9lectionner et filtrer\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg\",\"datePublished\":\"2022-11-08T04:59:00+00:00\",\"dateModified\":\"2022-11-23T09:05:00+00:00\",\"description\":\"Exemples de requ\u00eates SELECT SQL Server simples pour afficher les donn\u00e9es d'une table avec des filtres et des op\u00e9rateurs de s\u00e9lection.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Requ\u00eates SELECT SQL Server pour s\u00e9lectionner et filtrer\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Requ\u00eates SELECT SQL Server pour s\u00e9lectionner et filtrer","description":"Exemples de requ\u00eates SELECT SQL Server simples pour afficher les donn\u00e9es d'une table avec des filtres et des op\u00e9rateurs de s\u00e9lection.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"Requ\u00eates SELECT SQL Server pour s\u00e9lectionner et filtrer","og_description":"Exemples de requ\u00eates SELECT SQL Server simples pour afficher les donn\u00e9es d'une table avec des filtres et des op\u00e9rateurs de s\u00e9lection.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-11-08T04:59:00+00:00","article_modified_time":"2022-11-23T09:05:00+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Requ\u00eates SELECT SQL Server pour s\u00e9lectionner et filtrer","datePublished":"2022-11-08T04:59:00+00:00","dateModified":"2022-11-23T09:05:00+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/"},"wordCount":771,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/","name":"Requ\u00eates SELECT SQL Server pour s\u00e9lectionner et filtrer","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg","datePublished":"2022-11-08T04:59:00+00:00","dateModified":"2022-11-23T09:05:00+00:00","description":"Exemples de requ\u00eates SELECT SQL Server simples pour afficher les donn\u00e9es d'une table avec des filtres et des op\u00e9rateurs de s\u00e9lection.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Requ\u00eates SELECT SQL Server pour s\u00e9lectionner et filtrer"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1028","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=1028"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1028\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10607"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}