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!

Register Log in
  • 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!

Recent content by RobbieBHA

  1. RobbieBHA

    Selecting latest incidences

    Quote &quot;The syntax for Oracle is &quot; ... WHERE ROWNUM < 6&quot; &quot; 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...
  2. RobbieBHA

    Selecting latest incidences

    Thanks for the prompt reply and the hints. We are using Oracle 8i. Would this change the syntax at all? Rob.
  3. RobbieBHA

    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.
See more

Part and Inventory Search

Back
Top