? Thank you for reply !
Yes it works ! > Tue Apr 05 2016 11:06:52 AM CEST from "Graham Holden" ><SQLite at AldursLair.com> Subject: Re: [sqlite] How to order by absolute >value >? > > 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-mail at 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ?
