Re: Newbie Question - Setting a report in descending order
From: Dirk Bellemans <Dirk.Bellemans_at_skynet.belgium>
Date: Sat, 25 Sep 1999 17:43:48 +0200
Message-ID: <7skle4$duf$1_at_news0.skynet.be>
Date: Sat, 25 Sep 1999 17:43:48 +0200
Message-ID: <7skle4$duf$1_at_news0.skynet.be>
(Sorry for the late reaction)
You should not be afraid to add complicated statements in your SELECT or ORDER BY clause. They hardly hurt performance (as long as they don't perform a subselect of course). It is only in the WHERE clause that you need to avoid complicated expressions, because they might kill the optimizer.
-- Dirk Bellemans Modify email address to reply (use .be instead of .belgium) Connor McDonald wrote in message <37D39FF4.5547_at_yahoo.com>...Received on Sat Sep 25 1999 - 17:43:48 CEST
>
>select col1, col2
>from my_table
>order by ( col3 * col4 + 10 ) desc
>
>select col1, col2, col3 / 15
>from my_table
>order by 3 asc (ie same as order by col3/15)