{"id":223,"date":"2023-02-22T17:30:11","date_gmt":"2023-02-22T16:30:11","guid":{"rendered":"http:\/\/www.sepchat.com\/SC\/?page_id=223"},"modified":"2023-02-22T17:43:01","modified_gmt":"2023-02-22T16:43:01","slug":"sql2","status":"publish","type":"page","link":"http:\/\/www.sepchat.com\/SC\/index.php\/sql2\/","title":{"rendered":"SQL"},"content":{"rendered":"<form role=\"search\" method=\"get\" action=\"http:\/\/www.sepchat.com\/SC\/\" class=\"wp-block-search__button-inside wp-block-search__icon-button wp-block-search\"><label for=\"wp-block-search__input-1\" class=\"wp-block-search__label screen-reader-text\">Rechercher<\/label><div class=\"wp-block-search__inside-wrapper \"  style=\"width: 50%;border-width: 0px;border-style: none;border-radius: calc(100px + 4px)\"><input type=\"search\" id=\"wp-block-search__input-1\" class=\"wp-block-search__input\" name=\"s\" value=\"\" placeholder=\"Recherche\"  style=\"border-radius: 100px\" required \/><button type=\"submit\" class=\"wp-block-search__button has-icon wp-element-button\"  style=\"border-radius: 100px\" aria-label=\"Rechercher\"><svg class=\"search-icon\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\">\n\t\t\t\t\t<path d=\"M13.5 6C10.5 6 8 8.5 8 11.5c0 1.1.3 2.1.9 3l-3.4 3 1 1.1 3.4-2.9c1 .9 2.2 1.4 3.6 1.4 3 0 5.5-2.5 5.5-5.5C19 8.5 16.5 6 13.5 6zm0 9.5c-2.2 0-4-1.8-4-4s1.8-4 4-4 4 1.8 4 4-1.8 4-4 4z\"><\/path>\n\t\t\t\t<\/svg><\/button><\/div><\/form>\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-4\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-link-color wp-elements-4fb8bec5f54ef97c11c4d82b51ed91b0\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/ibm-i-des-couleurs-dans-le-resultat-dune-requete-sql\/\" data-type=\"post\" data-id=\"251\">IBM\u00a0i &#8211; Des couleurs dans le r\u00e9sultat d\u2019une requ\u00eate SQL<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:30:11+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-primary-color has-alpha-channel-opacity has-primary-background-color has-background is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-7\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-contrast-color has-text-color has-link-color wp-elements-6dfbf01ebd38d9fd5133231133b6f982\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/sqe-cqe\/\" data-type=\"post\" data-id=\"257\">SQE \/ CQE<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:90px\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:30:11+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-primary-color has-alpha-channel-opacity has-primary-background-color has-background is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-10\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-link-color wp-elements-5c68e09ccb83bedd0bcde3c3a4ab93fd\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/sql-comment-faire-un-comptage-horizontal\/\" data-type=\"post\" data-id=\"260\">SQL\u00a0&#8211; Comment faire un comptage horizontal<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:90px\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:30:11+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-primary-color has-alpha-channel-opacity has-primary-background-color has-background is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-13\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-link-color wp-elements-0747f8ce7564e886e475856862954bb3\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/sql-creer-une-table-temporaire\/\" data-type=\"post\" data-id=\"262\">SQL\u00a0&#8211; Cr\u00e9er une table temporaire<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:90px\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:30:11+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-primary-color has-alpha-channel-opacity has-primary-background-color has-background is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-16\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-link-color wp-elements-afb822522e47e3efa2f02c30a0f39288\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/sql-selection-du-premier-enregistrement\/\" data-type=\"post\" data-id=\"264\">SQL\u00a0&#8211; S\u00e9lection du premier enregistrement<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:90px\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:30:11+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-primary-color has-alpha-channel-opacity has-primary-background-color has-background is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-19\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-link-color wp-elements-6229c65b366d07231381bff7ba9c22f7\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/crypter-vos-donnees-par-sql\/\" data-type=\"post\" data-id=\"266\">Crypter\u00a0vos donn\u00e9es par SQL<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:90px\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:30:11+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-primary-color has-alpha-channel-opacity has-primary-background-color has-background is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-22\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-link-color wp-elements-b70dd5a77ee09a3d75defcfdcdf08d77\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/ibm-i-comment-lancer-une-requete-sql-par-commande\/\" data-type=\"post\" data-id=\"268\">IBM\u00a0i &#8211; Comment lancer une requ\u00eate SQL par commande<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:90px\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:30:11+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-primary-color has-alpha-channel-opacity has-primary-background-color has-background is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-25\">\n<div class=\"wp-block-column is-layout-flow\">\n<p class=\"has-link-color wp-elements-eb486850480ab20a1c3156c0ec72cec0\" style=\"font-style:normal;font-weight:300\"><a href=\"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/sql-gestion-des-dates\/\" data-type=\"post\" data-id=\"270\">SQL\u00a0&#8211; Gestion des Dates<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\" style=\"flex-basis:90px\"><div style=\"font-style:normal;font-weight:300;\" class=\"has-text-align-right wp-block-post-date\"><time datetime=\"2023-02-22T17:30:11+01:00\">22\/02\/2023<\/time><\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-28\">\n<div class=\"wp-block-column is-layout-flow\">\n<figure class=\"wp-block-image size-full is-resized has-custom-border\"><a href=\"sql\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/www.sepchat.com\/SC\/wp-content\/uploads\/2023\/02\/fleche-edited.png\" alt=\"\" class=\"wp-image-162\" style=\"border-radius:17px\" width=\"16\" height=\"16\"><\/a><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow\"><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>IBM\u00a0i &#8211; Des couleurs dans le r\u00e9sultat d\u2019une requ\u00eate SQL SQE \/ CQE SQL\u00a0&#8211; Comment faire un comptage horizontal SQL\u00a0&#8211; Cr\u00e9er une table temporaire SQL\u00a0&#8211; S\u00e9lection du premier enregistrement Crypter\u00a0vos donn\u00e9es par SQL IBM\u00a0i &#8211; Comment lancer une requ\u00eate SQL par commande SQL\u00a0&#8211; Gestion des Dates<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/pages\/223"}],"collection":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/comments?post=223"}],"version-history":[{"count":6,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/pages\/223\/revisions"}],"predecessor-version":[{"id":329,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/pages\/223\/revisions\/329"}],"wp:attachment":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/media?parent=223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}