Hi all,
I have a table (report_response) which has (among others)
fault_no and response_no fields. Now a fault_no can have
multiple response_no's.
The thing is, when I issue the following SQL:
SELECT fault_no ,one_line_summary FROM report_response
WHERE (reported_by LIKE '%J BLOGGS%' ) order by fault_no DESC
my returned list displays:
1355 Glish leftovers on sagitta
1350 Site phones
1350 Site phones
See those multiple occurances of 1350? This means there are 2 responses
to the fault_no = 1350. How can I fudge the SQL
to select the last response_no submitted?
Regards,
Stacy.
BTW: Using DBI:1.14 with Oracle 7.3.3