| Group, Sort, Distinct???? [message #428535] |
Wed, 28 October 2009 12:39  |
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  |
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:39I'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 |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
