Xref: alice comp.databases.oracle.server:33486 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail From: esiyuri@my-dejanews.com Newsgroups: comp.databases.oracle.server Subject: Re: ORDER BY clause without sorting needed... Date: Wed, 11 Nov 1998 11:20:29 GMT Organization: Deja News - The Leader in Internet Discussion Lines: 26 Message-ID: <72brtt$d8f$1@nnrp1.dejanews.com> References: X-Article-Creation-Date: Wed Nov 11 11:20:29 1998 GMT X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT) X-Http-Proxy: 1.0 x12.dejanews.com:80 (Squid/1.1.22) for client 194.201.219.130 In article , igoryok@soft-review.kiev.ua wrote: > I got a following troubles: I wish that my query result set will be not > sorted, but I with still have ORDER BY clause in it. Now I'm using 'ORDER > BY -1' and following query example works fine: Igor, maybe I'm missing the point here, but if you don't want to sort the result set, why not just leave out the ORDER BY clause? If the SQL is being generated by some sort of tool that doesn't allow you to do this you could try using "ORDER BY NULL", which doesn't result in a sort. I'm surprised that "ORDER BY -1" works at all... it looks like a bug to me. > P.S. Duplicate answers (if any :( ) to my e-mail please... Done. -- Regards Yuri McPhedran -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own