Christophe SEPCHAT - Consultant Indépendant : Devops, Modernisation, Organisation, Direction de projets |
SQL - Requète avec Tri conditionnel
LAST_UPDATED2
Il est possible d'effectuer un tri dans une requète SQL en y incluant une condition.
Par exemple, ma requète affiche la liste des adresses présentes dans ma table, triées par code postal. Cependan, je souhaite affichier les enregistrements dont le code postal sont à 0 en dernier.
SELECT ADR1, ADR2 , CODPO, BURDI, PAYS, FROM ADRES1PF ORDER BY Case
CODPO when 0 then 1 else 0 end, CODPO, PAYS
Top Articles
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_mostread/helper.php on line 79
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_mostread/helper.php on line 79
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_mostread/helper.php on line 79
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_mostread/helper.php on line 79
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_mostread/helper.php on line 79
Derniers Ajouts
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_latestnews/helper.php on line 109
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_latestnews/helper.php on line 109
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_latestnews/helper.php on line 109
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_latestnews/helper.php on line 109
Warning: Creating default object from empty value in /htdocs/public/c/modules/mod_latestnews/helper.php on line 109