CREATE TEMP TABLE a ( txt CHAR(4) ,val SMALLINT ) ; INSERT INTO a VALUES ("toto",1) ; INSERT INTO a VALUES ("titi",2) ; INSERT INTO a VALUES ("titi",9) ; INSERT INTO a VALUES ("toto",4) ; INSERT INTO a VALUES ("titi",6) ; INSERT INTO a VALUES ("toto",3) ; SELECT txt , val , CASE WHEN txt = "toto" THEN val WHEN txt = "titi" THEN -1*val END tri FROM a ORDER BY 1,3 ; txt val tri ---- --- --- titi 9 -9 titi 6 -6 titi 2 -2 toto 1 1 toto 3 3 toto 4 4
SELECT idvir, dateech, etat, montant, client FROM virement WHERE etat = 'D' ORDER BY etat, dateech ASC, montant UNION JOIN SELECT idvir, dateech, etat, montant, client FROM virement WHERE etat = 'R' ORDER BY etat, dateech DESC, montant
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSELECT distinct coddoc from tdcou where aneexe = 2010 order by 1 union SELECT count(serdoc) from tdcou where aneexe = 2010
SELECT distinct coddoc from tdcou where aneexe = 2010 union SELECT count(serdoc) from tdcou where aneexe = 2010 order by 1
( SELECT idvir, dateech, etat, montant, nomclient FROM virement WHERE etat = 'D' ORDER BY dateech ASC, montant ) UNION DISTINCT ( SELECT idvir, dateech, etat, montant, nomclient FROM virement WHERE etat = 'R' ORDER BY dateech DESC, montant )
(SELECT 1 AS sort_col, col1a, col1b, ... FROM t1) UNION (SELECT 2, col2a, col2b, ... FROM t2) ORDER BY sort_col, col1a;