Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Selecting latest incidences
Quote "The syntax for Oracle is " ... WHERE ROWNUM < 6" " This is close but only returns the first 5 rows in the report and not the first 5 rows for each practitioner. Each practitioner is identified by a 6 digit personal number called PERSNUM. Can anyone help? Thanks...- RobbieBHA
- Post #5
- Forum: Business Objects solutions
-
Selecting latest incidences
Thanks for the prompt reply and the hints. We are using Oracle 8i. Would this change the syntax at all? Rob.- RobbieBHA
- Post #3
- Forum: Business Objects solutions
-
Selecting latest incidences
I have a database of treatments provided and I need to select just the latest 5 incidences of a certain treatment code for each practitioner. I have the date of each treatment and wonder if there is anyway I can do this automatically in BO? Thanks in advance, Rob.- RobbieBHA
- Thread
- Replies: 6
- Forum: Business Objects solutions
