Home » Developer & Programmer » Reports & Discoverer » Group, Sort, Distinct???? (Oracle Discoverer)
Group, Sort, Distinct???? [message #428535] Wed, 28 October 2009 12:39 Go to next message
kp223
Messages: 1
Registered: October 2009
Junior Member
I'm trying to run a report and I need to organize it differently, this is what I have:

SerialNum | AcctNum | AcctName | Address | CallDate| UpTime%


Each time a client reports a problem, it gets logged. I do not want every single call for each serial number.

I want all of the info for the most recent CallDate

I'd really appreciate the help!
Re: Group, Sort, Distinct???? [message #429981 is a reply to message #428535] Fri, 06 November 2009 12:14 Go to previous messageGo to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Why dont you use the GROUP BY function?kp223 wrote on Wed, 28 October 2009 12:39
I'm trying to run a report and I need to organize it differently, this is what I have:

SerialNum | AcctNum | AcctName | Address | CallDate| UpTime%


Each time a client reports a problem, it gets logged. I do not want every single call for each serial number.

I want all of the info for the most recent CallDate

I'd really appreciate the help!

Re: Group, Sort, Distinct???? [message #429982 is a reply to message #428535] Fri, 06 November 2009 12:22 Go to previous message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> select * from (select * from emp order by hiredate desc) where rownum=1;
     EMPNO ENAME      JOB              MGR HIREDATE           SAL       COMM     DEPTNO
---------- ---------- --------- ---------- ----------- ---------- ---------- ----------
      7876 ADAMS      CLERK           7788 23-MAY-1987       1100                    20

1 row selected.

Regards
Michel

[Updated on: Fri, 06 November 2009 12:23]

Report message to a moderator

Previous Topic: Complex situation
Next Topic: Dont wants to show certain matrix columns
Goto Forum:
  


Current Time: Mon Sep 26 05:54:45 CDT 2016

Total time taken to generate the page: 0.16657 seconds