Home » Developer & Programmer » Reports & Discoverer » Order by Problem in Oracle Reports
Order by Problem in Oracle Reports [message #87891] Fri, 19 October 2001 01:52 Go to next message
Manjunath
Messages: 9
Registered: July 2000
Junior Member
Hello,I am facing a problem with order by in oracle reports. I have query like select col1, col2, count(*) from table1, table2 where <condn> group by <col> order by count(*) desc. This is executing in PL/SQL prompt and i able to order by descending but the same is not allowing in Reports. Can anyone look at the problem and give a solution.
Thanks in advance
Shetty

----------------------------------------------------------------------

Report message to a moderator

Re: Order by Problem in Oracle Reports [message #87902 is a reply to message #87891] Tue, 23 October 2001 01:25 Go to previous message
Lars Sjöström
Messages: 24
Registered: June 2001
Junior Member
Maybe you should do "order by 3" instead.

and also at the same time put in aliases for the selected columns.

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: Urgent ..pls help
Next Topic: Re: oracle discoverer 3.1
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 04:41:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.