Change "select abs(num)" in your second example to "select num" and you should be good. I'm guessing in your first example the ORDER BY only applies to the last SELECT.
Graham. Sent from Samsung Mobile -------- Original message -------- From: Domingo Alvarez Duarte <sqlite-m...@dev.dadbiz.es> Date: 05/04/2016 09:47 (GMT+00:00) To: SQLite mailing list <sqlite-users at mailinglists.sqlite.org> Subject: [sqlite] How to order by absolute value ? Hello !? I want to achieve this:? select 1 as num union select 3 as num union select -2 as num order by abs(num) -- result [1, -2, 3]? But it doesn't work this works but doesn't show what I want:? select abs(num) from ( select 1 as num union select 3 as num union select -2 as num ) order by abs(num) -- result [1,2,3]? ?? I know I can duplicate the column value but there is a way to do it without duplicating ?? ?? Cheers ! _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users